I am trying to build a simple zap workflow between Airtable and Google Sheets. The idea is to create a database on Google Sheets replicating the records in Airtable when they are assigned a certain statuts.
When this status is attributed on Airtable → a data entry is created on the GS sheet
When this status is removed or changed on Airtable → the data entry should be deleted on the GS sheet
I am basically looking for 1. creating a record in a Google Sheets database when a record is created on view on Airtable (the criterium being a “status”)
2. deleting a record in the same GS database when a record’s status changes
For n°1, It seems to be working
For n°2, I am trying to combine a Lookup Spreadsheet Row in Google Sheets + Delete Spreadsheet Row in Google Sheets as adviced by Zapier. It should screen the database to find a record and delete it subconsequently.
The lookup step seems to be working according to Zapier “Test”
The DeleteRow part however does not seem to comply, sending me a message error
“We had trouble sending your test through.
invalid literal for int() with base 10: 'Fumigène'
I don’t understand the error message and am a bit lost regarding the fix to provide.
Does anyone have a clue on this ?
Many thanks !
Best answer by nicksimardView original