#Sync airtable and google sheets update#
#Sync airtable and google sheets full#
#Sync airtable and google sheets professional#

It is frustrating re AT’s stance on this - at least have a revenue model built around it so you give users the option.

#Sync airtable and google sheets professional#

I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link above contains my personal referral code. If you add a new row to the bottom of a Google Sheets spreadsheet, that information CAN be sent back to Airtable.

#Sync airtable and google sheets update#

For example, you can send back an update that takes place in an existing Google Sheets row, but you can’t insert a brand new row into the middle of a Google Sheets spreadsheet and then send that row’s information into Airtable. Due to Google’s API limitations, you can only send back certain types of updates back to Airtable. This would be somewhat tricky to implement & setup everything appropriately (and you can hire a professional Airtable/Integromat consultant like myself to help you with this), but note that there are also limitations with this approach as well. You would need to set this up with a tool like Integromat, which could sync your Google Sheets updates to Airtable.

Otherwise, if you want to do this with Google Sheets, you already noted the answer above yourself. So there are definitely problems with Stacker, but you can be fully up & running within a few hours at most.

#Sync airtable and google sheets full#

However, Stacker has some very serious limitations that you need to know about - for example, it only syncs data from Airtable every 15 minutes, and it doesn’t have full support for many field types. You can very easily do what you’re looking to do with Stacker, which provides a completely customizable front-end user interface to Airtable. Shared views are open to the public, who don’t provide any revenue to Airtable. Yep, it’s surprising that Airtable has never implemented shared views with editing capabilities yet, although I’m certain that it has something to do with their revenue model. Once the client update the relevant fields in Google Sheets, is there any way of syncing this info back into Airtable so that the Master table is always updated and synced with the latest information and updates? Now that the info is in Google Sheets, it can be shared with a client (either the full set of data and hide various columns and restrict editing access or importing a revised view from AT). So, the only option is to send this information to Google Sheets (I am aware of various tools such as Airtable Importer, Coupler, Integromat etc that can do this one way).

Only issue here is that when sharing this view a guest can view it and not make any changes (I am amazed that this feature is still yet to be implemented having seen discussions on this topic go back quite a long way). Obviously this can be done by setting up a view and hiding the relevant fields. Ideally I would like to be able to share a “filtered” view with a clients that only shows information relevant to them for a updating various aspects of a project, while the remaining fields which are for internal purposes are hidden. I am wanting to understand if the following scenario is currently achievable and if so, what “add ons” would be required: