Hello. Thanks for any help regarding this.
I have an integration running in Google Sheets where Amex charges are downloaded into a Google sheet, almost realtime. My goal is to create a connection so that when a record is created in Google Sheets it is copied into an Airtable base. I think it should be just one way from Google Sheets to Airtable.
The challenge is that the integration between Amex and Google sheets deletes all existing records and does a full re-creation of ALL the records in the Google Sheet whenever a single row is added.
I didn’t realize this when I created a Zapier Zap to create a new record in AirTable every time a record was added to the Google Sheet. Before long I had thousands of Zaps on hold. For example, in the Google sheet if one new Amex charge is added, for some reason it deletes the 500 existing rows and adds back 501 new rows. I asked support for that product why they do it, but I’m certain they’ll have their reason. Just haven’t heard back yet.
So to make this work, I have a transaction ID from Amex which I think does not change. So, I need to conditionally have something like this:
- New row created in Google Sheets
- Check to see if that transaction ID for the Google Sheet row exists in any Airtable record
- If it doesn’t, copy the record over
- If it does, skip.
So, I think I understand the process, just not sure how to implement it in a Google Sheets Airtable automation.
Thanks again for any help.