Airtable Importer: Google Spreadsheets add-on

@Dmitry_Pliska That’s Brilliant!

Very useful extension to Airtable thank you, particularly the easy refresh. This beats having to re-download an Airtable csv.

It would be good if the auto refresh interval could be longer than one hour as I left my sheet open during the day while I was doing other things and when got back to my PC, there was a message that I had exceeded 12 (I think it was) refreshes and was blocked from doing any more.

@Dmitry_Pliska This add on is awesome, thanks for making it publicly available! I’m using it to add visualisation capabilities to Airtable, so now it’s possible to have dashboards connected to airtable data which is great. Also, I’ve been sending airtable data all the way to Google Data Studio via a google sheet, with the help of your add on :slight_smile:

I’ve got a specific use case which I wonder if you folks can help with. For spreadsheets which have multiple Airtable data sources coming in to different tabs, it seems that we hit errors on the automatic refresh function. In the sidebar, I see a message like: you have too many time-based triggers for this google account.

To get around this problem, is there a way we can refresh ALL the sheets by using a single time-based trigger? I had an idea of attaching my own script to the spreadsheet that triggers the ‘re-import all sheets’ menu item every day… but I can’t figure out if scripts can trigger menu items :frowning:

Hi everyone! I started using Airtable Importer this afternoon and I was totally excited when I saw it working. Now, when playing around with it at home I see strange behavior of the add-on: The menu suddenly only shows “help”. The sidebar seems gone, too. Maybe it’s because I have deleted my shared link in Airtable? Unfortunately I cannot reset Airtable Importer. What happened?

Looking forward to help.

Thanks & best regards,

Kai

Hi Kai,
Thank you for the good feedback.

In order to solve your issue, most likely you just need to make sure you did enable the add-on for the particular spreadsheet like shown here:

Hi Rupert,

As far as I know, this is not possible for the time-based triggers. If that makes it any easier, we do have “re-import all sheets” menu item within the add-on menu but its manual.

1 Like

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

Fantastic! Thank you!

@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

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?

Thanks!

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

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

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…

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

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.

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.

Awesome work, congrats!

One question though, what about security?

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

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

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