Hello all!
What would be your recommendation to continuously import new data added to a google sheets?
The doc advises to export -> csv -> import into clay, but this is not ideal for a continuously expending google sheet.
For continuously importing new data from Google Sheets to Clay, you can set up an automated system using Google Apps Script with a webhook table. Here's how it works:
1. Create a webhook table in Clay (note: this is an enterprise-only feature that works with passthrough tables)
2. Set up a Google Apps Script in your Google Sheet that will:
• Cycle through rows in your sheet
• Send data to Clay via the webhook
• Mark processed rows to track progress
• Run periodically to handle new data
The script can be configured to:
** Process a specific number of rows
** Control the sending rate to match your enrichment timing
* Track which rows have been sent to Clay
This automated approach is more efficient than the manual process of exporting to CSV and importing into Clay.