My clients always want their scraped leads delivered in a Google Sheet. I’ve been using Zapier to catch the JSON from my scrapers and append the rows, but the Zapier bill is getting out of hand.
How hard is it to connect RTILA directly to Google Sheets?
It’s super easy. I moved all my client sheets over to RTILA last month. You just need a GCP Service Account JSON key. Paste that into the RTILA trigger, give it the Spreadsheet ID, and tell it to append_row. It formats the data perfectly.
Glad to hear it’s working well for you, @scrapeninja!
To add to that, the Google Sheets trigger is incredibly smart. If you don’t have a Spreadsheet ID yet, you can just provide a spreadsheet_title and a parent_folder_name. The Python Relay will actually search your Google Drive, create the folder if it doesn’t exist, create a brand new spreadsheet, and even share it with your client’s email address automatically before appending the scraped data. It completely replaces the need for Zapier.