Im getting this error message "The app returned "NOT_FOUND""

Hi @Trev Chee 

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?

@Trev Chee 

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

@Trev Chee 

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?

@Trev Chee 
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. 

@Trev Chee 

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:

• The first row must have titles for any column headers you want to be able to see in your Zap.
• The second row must have content for any columns you want to be able to see in your Zap.
• There can be no completely blank rows before the end of your spreadsheet.

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 

@Trev Chee 

This article might be helpful:

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

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.