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 originalDon’t worry so much about those fields being red on that screen, when you test those data points will populate if you have selected them in the configuration section for that Zap step.
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.
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
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…
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 read through the second last link you sent and although it was interesting, it didn’t answer my question connecting gSheets to Airtable.
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’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?
So is this automation possible?
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.
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?
This is the google sheets tab (Above)
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.