Data Sync & ETL
Sync New MySQL Rows to Google Sheets
Every few minutes, it selects unsynced rows from MySQL, appends them to Google Sheets, and marks them as synced to avoid duplicates.
What it does
Update all the got data with column sync = 1 to prevent duplication in next run
The steps
- Select rows from a table
- Append row in sheet
- Update rows in a table
- Schedule Trigger Every n Mins
- No Operation, do nothing
- Check if new record returned
Similar automations