Automations between Airtable and Google Sheets

[George_Kimpton-]

I am trying to generate my table responses in a google sheet however I am finding when I submit a new entry it sometimes enters twice on sheets and when i go to edit an entry, it will add a new entry as opposed to altering the initial one.

Any help on sorting this out will be appreciated!

[ScottWorld]

The Google Sheets action only supports adding a new row.

If you need to update an existing row, you would have to turn to (a) custom scripting or (b) external automation tools which are low-code.

Personally, I like using Make.com (formerly known as Integromat) for these purposes.

I am also an Expert+ Partner of Integromat/Make, so if you need help with implementing this and you have a budget for your project, feel free to reach out to me through my website at scottworld.com:

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable Consulting,...

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable...

ScottWorld provides the world's best Airtable consultants, Airtable experts, Airtable developers, FileMaker consultants, and Airtable trainers. Airtable consulting, FileMaker development, and Airtable training.

[Hannah_Wiginton]

Hey @George_Kimpton-Moss -

We have 2 helpful Google Sheets functions in our On2Air Actions app that can do more than the basic Google Sheets integration in Airtable.

The 1st - Google Sheets Export - allows you to set up a template in Google Sheets and it will automatically add your Airtable data based on whatever trigger you set.

The 2nd is a full Airtable to Google Sheets sync where it will sync your entire table each time.

On2Air | Accomplish Anything with Airtable – 8 May 21

On2Air: Actions | On2Air

On2Air: Actions is an Airtable automation and workflow tool to integrate and connect your Airtable data with any other software tools used in your business. Create powerful business processes with almost 20 additional action options beyond the...

[George_Kimpton-]

This sounds fantastic, are you able to message me directly and we can discuss having this implemented?

[Hannah_Wiginton]

Yes, will do. Thanks