4/9/2024 0 Comments Google drive airtable zapier![]() ![]() To see how to add placeholders to your own template, see the Google Sheets Template Placeholders GuideĨ. Our Promotion Tracker Google Sheets template is already set up with the corresponding to the Airtable fields in the Marketing Promotions base In this case, choose the Promotions Tracker Google Sheets file you added to your Drive. In Source File, choose your Source/Template file. Each contains different information or has a different layout.ħ. You can create multiple templates that are chosen based on specific values in your base.Įxample: If you have a select field called Status with values of New, In Progress, and Completed, you can have 3 Google Sheets templates for each Status. If you need files based on conditions or values in your Airtable records, you can use our dynamic option to use different files for different Airtable records. Then in Source File Mode, choose Use a Single Template. Next, choose your Google Drive connection. In this case, we’re using the Checkbox field, chose “Send to Google Sheets” Checkbox field, and will trigger it when it’s CheckedĦ. You can use a Checkbox field, when a field is updated, when a particular date is selected, a custom formula, a Last Modified date field, or only on specific records. Choose when you want the spreadsheet to be created. Click Add Configuration and then choose your Airtable connection, your base, and your table.ĥ. Here’s a tutorial on how to do a full Airtable table to Google Sheets sync)Ĥ. (note: we also have a Google Sheets Table Sync automation for an entire table sync. In the On2Air dashboard, open the Docs app ![]() To follow along with this tutorial, copy the Marketing Promotions Airtable base to your workspace and the Promotions Tracker Google Sheets file to your Google Drive.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |