Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Appending to Google Sheets, how to post last modified value not lengther

Topic Labels: Automations
Solved
Jump to Solution
322 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Howdy,

I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever

airtable

1 Solution

Accepted Solutions

Hi @Mark_Hostetler - I don’t think this is going to work. I’m guessing your automation is something like:

At a scheduled time → Find Records → Append Row to Google Sheets

The problem is that Find records returns a list or an array of records and you need a way to iterate through these to append them as individual rows on the Sheet. However, Airtable Automations don’t offer an iterate component directly.

One way around this would be to run a script in the automation as the 3rd part, but this is going to need a lot more coding (the script would be able to iterate through the list of records returned and post them to the Sheet).

Another way would be to change the automation to work off a view - e.g. when a record enters a view. Here your view might be when the created at time is more than 10 minutes ago. In this scenario, you’re dealing with each record individually, so you can append to the Sheet easily. The downside of this method is that every record triggers the automation, so you burn through a lot more of your automation allowance.

See Solution in Thread

2 Replies 2

Hi @Mark_Hostetler - I don’t think this is going to work. I’m guessing your automation is something like:

At a scheduled time → Find Records → Append Row to Google Sheets

The problem is that Find records returns a list or an array of records and you need a way to iterate through these to append them as individual rows on the Sheet. However, Airtable Automations don’t offer an iterate component directly.

One way around this would be to run a script in the automation as the 3rd part, but this is going to need a lot more coding (the script would be able to iterate through the list of records returned and post them to the Sheet).

Another way would be to change the automation to work off a view - e.g. when a record enters a view. Here your view might be when the created at time is more than 10 minutes ago. In this scenario, you’re dealing with each record individually, so you can append to the Sheet easily. The downside of this method is that every record triggers the automation, so you burn through a lot more of your automation allowance.

That would explain my other issues as well! Thank you for clarifying this!