You can easily make your Google Sheets feed more usable by adding some filters, drop-down lists, headers, and colors. See the two examples below. You can preview the first example here.
Use a Google Sheets feed as an asset library for your ad creatives. Easily move winning creatives from test campaigns to evergreen campaigns with drop-down lists and campaign level filters in Automated Ads. Switch one cell to Evergreen and the ad creative is automatically created in the evergreen campaign:
Another useful trick allows you to add standardised dates to your spreadsheet, this is especially useful to set start and end dates of your ads and leverage the possibility to automate the scheduling of your creatives via Automated Ads. Additionally, this makes sure that multiple people touching the same sheet use the same format.
You will be able to open a calendar by simply double-clicking a cell and pick and choose your favourite date from there by selecting any cell(s) you want and clicking on Data>Data Validation and using a valid date as Criteria, as shown below:
You can find useful info on Time-based filtering via Automated Ads in this article on our support center.
Learn more at: