Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Airtable / Google Sheets integration : "invalid literal for int()" when I try to combine lookup + deleterow

Hi everyone,

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 !

Alexandre

Hi Alexandre,

I checked this out for you and it looks like this particular error has come up fo a handful of users in the past several months. One thing I see is that it can happen if you’re trying to delete a row that has already been deleted.

Also, are you using the custom value option in order to delete the exact row that you’ve found in your search step? A common confusion is that users will select a specific row from the dropdown instead of referencing the one they’ve found via their search step.

And you do that by selecting the Row field:

 

 

Can you check to make sure you’re doing it that way? Thanks!

Terms & Conditions