Airtable Importer: Google Spreadsheets add-on


Solved! Thanks a lot Dmitry. I don’t know why but I had to sign off from my Google account and re-login. All fine!



Fantastic! Thank you!


@Dmitry_Pliska I’m getting an issue with the add on. It gives me the following error:

Error: Request failed:

It doesn’t matter what base I try to use it from, so I cut off the rest of the sharing link there, but I do give it a full valid link. Please advise.


Hi Larry,
Sorry for inconvenience, sometimes server goes down. Just restarted it, should work fine.


Hi @Dmitry_Pliska!
Thanks for this awesome Add on.

Question, is it possible to have Airtable only update the columns that are actually in Airtable? Meaning, if Airtable only has 3 columns, and I have 7 columns in Sheets, whatever is in column 7 will still get erased upon update from the Add on, even though there is no 7th column in Airtable. Is there a way to protect data added in Sheets so that it doesn’t get erased when the update goes through?



Hi, no, add-on just re-imports Airtable data and overwrites the whole sheet.
As a solution, I would suggest you to follow approach we are using in the company:

  • all sheets that are filled with Airtable imports are left “as is”, so called “datasource”, with no formulas etc.
  • at another sheet use references like =datasource!A1:L38 and use this sheet as you want since it’ll never be overwritten by Airtable Importer

Hope it helps :slight_smile:


google spreadsheets is able to export (export) airtable data with this application



Just installed this today.

It pulled the data for the first time and since has show the following error.

Script Error - No item with the given ID or you dont have permission.



Thank you, Jason for your interest in our add-on! We’re in touch in support tread. Hope you’ll get the issue resolved soon.
Pavel Pavlovsky
Product Manager at Railsware