Google Sheets
You can have your rule write data to Google Sheets as an action. First, you'll want to go to Action Destinations and create a Google Spreadsheets Destination.
Please email [email protected] to access the JSON key file needed to configure the destination
Share your Google Sheet with [email protected]
Next, attach an Action Subscription to your rule that will write to your Google spreadsheet. All you have to do is paste in the URL of your Google sheet and specify which tab number you wish to write to (to specify the first tab enter the number 0, second tab 1, third tab 2 and so on). When your rule runs, it will write all the rows returned from your SQL query into the spreadsheet.

Last modified 2mo ago
Copy link