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.

How to automate daily records to Spreadsheet without any extensions or thirdparty

Topic Labels: Automations Data Formulas
Solved
Jump to Solution
768 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cdones
4 - Data Explorer
4 - Data Explorer

Hello there, I would like to know how make an automation of daily record updates to the Spreadsheet? I've read some posts in this forum and all of them were asking to use a third party which needs to pay more again. How to do it just in airtable?

In my thought, it should be like this

- At the end of the day
- Check which records are created today
- Send every record to spreadsheet
- Done

Please help, thank you!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

If you're using Google Sheets, the "Append Row" action should work for what you need? 

Screenshot 2024-06-28 at 10.37.17 AM.png
You'd create an automation that triggers at the end of the day and use a 'Find Record' action to look for all the records created on that day.  You'd then use a repeating group on the results of that list and you could then use 'Append row' action in that repeating group

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

If you're using Google Sheets, the "Append Row" action should work for what you need? 

Screenshot 2024-06-28 at 10.37.17 AM.png
You'd create an automation that triggers at the end of the day and use a 'Find Record' action to look for all the records created on that day.  You'd then use a repeating group on the results of that list and you could then use 'Append row' action in that repeating group

cdones
4 - Data Explorer
4 - Data Explorer

Yes! thank you so much it works!

cdones_0-1719581186440.png