Re: Need help with automation, pretty please!
Yes! Here is my trigger:
And here is my action:
And the tests are running fine. And I keep seeing “ran successfully” as I enter new records but the spreadsheet remains stubbornly empty.
Okay - I just set up what is ostensibly the same process and sheet and it works as advertised but not necessarily as you might expect. More on that later. At the outset, there is likely an authorization issue or a data type issue preventing the data from replicating into the target sheet. I would try deleting the automation and rebuilding just to rule out some sort of security issue.
If that doesn’t help, I would look at the selected Airtable fields as a potential source of failure. Try with just two text fields to see if that works, and then add the date field. This may demonstrate that you have a field format in Airtable that Google is;t prepared to receive, thus causing an issue.
As new records are added to the view, they are added to the sheet - my test seems fine. However, removing a record from the view will not cause the record to be removed from the sheet because this code-free automation feature only supports appending rows to sheets.
As indicated by this action, it will only serve to append new rows in the target sheet when – and only when – the record moved from not in the view, to in the view. It has no capacity to modify specific fields in the reflected sheet row. To do that, you need to take @ScottWorld suggestion concerning Integromat or use script automation. I’m certain this can be done with script, but I am uncertain if Integromat supports field-level edits in a synched Google sheet.
Possible Sheet Update Remedy
One idea to overcome the lackluster support for true sheet synching from Airtable is to always append the rows to the target sheet, but have another automation script process in the spreadsheet delete all rows every 15 minutes.
I believe this may cause the automation script to recreate the rows in the target sheet using the latest data changes made on the Airtable side. I have not tested this, so it’s purely hypothetical at this point.
The script (in Google) to delete all rows is:
// This example assumes there is a sheet named "first"
var ss = SpreadsheetApp.getActiveSpreadsheet();
var first = ss.getSheetByName("first");
first.clear();
This could be created in a few minutes and triggered to run every 15 minutes. This is all free on the Google side as well.
