Airtable Importer: Google Spreadsheets add-on

Show and tell
#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.

1 Like
#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:

1 Like
#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

#31

We use Google Sheets with several tabs, formulas, vlookups, and links to data in other tabs. A .csv import into Airtable won’t capture all that complexity. Can your add-on do it?

Once we’ve imported everything, we won’t use Google Sheets anymore.

#32

Google Sheets and Airtable follow two very different… well, ‘world-views’ is probably not far off. In Airtable’s case, the spreadsheet analogy is perhaps best thought of as the ‘elevator pitch’ for the product; a spreadsheet-based application design cannot be easily ported. Your best approach would be to strip the Sheets app back to functional requirements and reimplement the application under Airtable. If that’s more than you’re willing to take on yourself, there are a number of Airtable-savvy consultants and integrators available to help.

#33

Awesome work, congrats!

One question though, what about security?

Can the developers, devops or someone from Railsware see my data?

#34

Thanks Railware for sharing this awesome add on with the Airtable community and for making the basic tier free to use. We’ve mentioned you in a blog on how to connect Airtable to Google Data Studio by using your add on! https://medium.com/@optimi/you-too-can-make-dashboards-how-to-visualise-your-airtable-data-in-google-data-studio-d376bf4ccfaf

2 Likes
#35

for all who have been watching and commenting on this topic:

I would like to invite you to contribute to this topic “Coupler.io add-on to pull data from Airtable to Google Sheets” where we announce the launch of Airtable Importer’s brother product, a more powerful Coupler.io.

You are most welcome to join us on this journey now!

2 Likes