Airtable Importer: Google Spreadsheets add-on

#21

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!

K

#22

Fantastic! Thank you!

#23

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

Error: Request failed: https://airtable-proxy-server.herokuapp.com/?sharedUrl=https://airtable.com…

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.

#24

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

#25

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?

Thanks!

#26

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:

#27

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

#28

Hi,

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.

Jason…

#30

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