- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2025 08:29 AM
Hi All, I'm new on using Airtable Automations and have been trying to sync content with a Google Spreadsheets file.
Once using the "When record update" trigger type, I've observed that each "enter" command made by the user when typing on a specific cell/field in Airtable creates a new row in the GSheet tab.
My question is: how to assure that the GSheets will reflect and store only the final status, i.e., the most up-to-date content in Airtable?
Rks in advance for your thoughts!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2025 10:12 AM - edited ‎Feb 14, 2025 10:12 AM
You would need to create either a checkbox field or a single-select field for the user to select when they are done editing the entire record in Airtable, and then you would trigger the automation off of that field.
I discuss this more in this thread.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2025 05:39 PM
Hi ScottWorld, tks for your attention.
I've tried to insert a "timestamp" field in Airtable to capture the most recent update and, once returned in GSheets, I could consider the "query" or "unique" function to deduplicate the similar records - however, I can see that the records are returning in some cases the same timestamp...
That happens mostly when the user is editing in Airtable a "multiple choice" field type, where predefined options are populated and then one or more option can be selected. It seems that for each selected option the Airtable Automation is triggering an update...
Tks All for any thoughts!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2025 08:09 AM
Hi Leone!
If you're going to use Airtable Automations for this, +1 to ScottWorld's suggestion around using a checkbox or single select that determines if the user is "editing" or not and only sends updates once editing is complete.
Alternatively, I might suggest reaching for a dedicated tool for this like Whalesync (my product).
The Airtable x Google Sheets 2-way sync which will just handle all the logic for you out-of-the-box: https://www.whalesync.com/connect/airtable-google-sheets
