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

[cdones]

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!

[TheTimeSavingCo · Accepted solution]

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

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]

Yes! thank you so much it works!