Feb 09, 2017 07:07 AM
Hi all,
We discovered Airtable as awesome organizational database tool and started to use it extensively. We loved it for the way it’s organized and well-thought.
But what we really missed there is “Google Sheets magic”:
With that in mind, we developed an Google Spreadsheets add-on as a missing link between Airtable and Google Spreadsheets.
We made it to solve particular issues within our company and for internal use only. But we thought that this add-on can help other people to make their lives better by combining powers of two great database tools: Airtable and Google Spreadsheets we shared it with other people. So anyone is welcome to give it a try.
Webpage:
http://railsware.com/case-studies/airtable-importer/
Download: https://chrome.google.com/webstore/detail/airtable-importer-by-rail/kngidnifbonbaembhpnjlpeefhmjpegb
Thanks.
Oct 20, 2017 12:40 AM
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
Jan 04, 2018 12:28 PM
Fantastic! Thank you!
Jan 10, 2018 05:02 PM
@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.
Jan 11, 2018 02:21 AM
Hi Larry,
Sorry for inconvenience, sometimes server goes down. Just restarted it, should work fine.
Apr 06, 2018 08:33 AM
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!
Apr 13, 2018 08:55 AM
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:
=datasource!A1:L38
and use this sheet as you want since it’ll never be overwritten by Airtable ImporterHope it helps :slightly_smiling_face:
Sep 19, 2018 02:49 AM
google spreadsheets is able to export (export) airtable data with this application
Oct 28, 2018 10:55 AM
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…
Nov 05, 2018 02:03 PM
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
Dec 22, 2018 04:14 PM
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.
Dec 22, 2018 06:46 PM
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.
Apr 24, 2019 06:10 PM
Awesome work, congrats!
One question though, what about security?
Can the developers, devops or someone from Railsware see my data?
May 12, 2019 12:30 AM
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...
Apr 02, 2020 05:29 AM
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!
May 14, 2023 11:26 PM
Nov 09, 2023 04:29 PM
In my personal opinion, the best & easiest way to communicate between Google Sheets and Airtable is to use Make's Google Sheets automations & integrations.
There is a small learning curve with Make, which is why I created this basic navigation video to help. In that thread, I also provide the links to a few other Make training resources there as well.
p.s. If you'd like to hire an expert Airtable consultant to help with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld