Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Airtable to Google Sheets - multiple rows

Topic Labels: Automations
288 1
cancel
Showing results for 
Search instead for 
Did you mean: 
NWPKelly
4 - Data Explorer
4 - Data Explorer

I'm having trouble at a couple of points, and there may be multiple ways to fix this. 
Firstly, I need this automation to happen once a week. Let's say I pick Thursday - I need it to run this automation on all records on a particular table that have the date as 8 and 9 days away. But I can't find how to make it a weekly repeating automation. 
Then, lets say that there are 6 records that fall on those dates. If I have that data sent to a google sheet, it puts all 6 rows from AT into just 1 row on GS. Is there no way to have it go to multiple rows? 
I have tried using a workaround of sending it to a Google Doc as a grid instead - but is there anyway to manipulate what order the columns are in? It looks like I can just select them or not, but the order I use them in for this purpose is different than the order we need them in for AT purposes. 

1 Reply 1

Try creating a formula field that'll help you check whether the record has a date that's 8 or 9 days away:

Screenshot 2025-01-23 at 12.53.32 PM.png

IF(
  OR(
    DATETIME_DIFF(
      Date,
      TODAY(),
      'days'
    ) = 8,
    DATETIME_DIFF(
      Date,
       TODAY(),
      'days'
    ) = 9
  ),
  'True',
  'False'
)

Then, create an automation that runs once a week and give it the following actions:
1. Find Record action to look for all the records that have a formula field output of 'True'
2. Repeating group that takes the output of the 'Find Record' action
3. Google Sheets Append Row per item in the group

Should do what you need!

Screenshot 2025-01-23 at 12.55.17 PM.png

Link to base