Im getting this error message "The app returned "NOT_FOUND"". I'm trying to create a new record in Airtable when a new row in google sheets is created. This is the first time using Zapier.
Best answer by Troy Tessalone
View originalIm getting this error message "The app returned "NOT_FOUND"". I'm trying to create a new record in Airtable when a new row in google sheets is created. This is the first time using Zapier.
Best answer by Troy Tessalone
View originalHi
What Zap step returned the error? (Airtable or GSheets)
Can you provide screenshots of how each of your Zap steps are configured?
My team is reluctant to using Airtable to update the sales orders. They still want to use Google Sheet only. So I’m trying to learn how to use Zapier to automatically add and update a record in Airtable every time a new entry in Google Sheets is made.
I’m not able to successfully get through the “test & review” steps in Zapier
This is the google sheets tab (Above)
This is the new “tab” I created in AirTable. To create this, I just copy and pasted the data from Google Sheets into the Airtable tab. Is this the correct way to do this?
Based on your screenshot it appears the field name being used no longer exists or has been renamed.
Check your Zap setup and perhaps pull in a new record to test with.
Also, reference these help articles: https://zapier.com/apps/airtable/help
This is the new “tab” I created in AirTable. To create this, I just copy and pasted the data from Google Sheets into the Airtable tab. Is this the correct way to do this?
Airtable and GSheets while similar have many difference.
Airtable works on a row by row basis for the data, so copying over the structure of the GSheet into Airtable won’t achieve the same results.
So is this automation possible?
I’m trying a different option for the action in Airtable. I’ve chosec “Create A Record” Instead of “Update Record”. But i’m still getting an error message. What am I doing wrong?
Having the GSheet structured the way it is won’t work with a Zap.
Check out this help article: https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier
I read through the second last link you sent and although it was interesting, it didn’t answer my question connecting gSheets to Airtable.
Some notes from the article which should help point you in the right direction about how the GSheet needs to be structured to work with a Zap:
Might be worth reviewing that article again to ensure your GSheet is structured correctly.
I will try to re-structure the gsheet and see if it works. Thank you for your help. I will let you know if it works…
I rearranged the whole structure of GSheets.
it’s not giving me an error code like last time. but when I go to test the updated records, it still doesn’t go through
This article might be helpful:
The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.
While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.