Import New Google Sheet Rows to Table with Clay Integration
Hey! Is there a way for Clay to check for new rows on a Google Sheet, and import them directly to a table?
Hey! Is there a way for Clay to check for new rows on a Google Sheet, and import them directly to a table?
Hey there, thanks for reaching out! ☺️ 1. You can use Google Apps Script within Google Sheets to automate the data transfer to Clay. A video guide is available here 2. You can also use a service like Make.com to check the spreadsheet on a recurring basis, and send the new rows to Clay. We have a video on that sort of setup here: https://www.loom.com/share/7ea0148442bb4e7791ad7dd19e869a8a And the scripts from the video: JS
const WEBHOOK_URL = 'https://your-clay-webhook-url.com'; // Replace with your webhook URL
function sendNewRowsToClayWebhook() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = sheet.getDataRange().getValues();
const lastRowSent = PropertiesService.getScriptProperties().getProperty('lastRowSent') || 1; // Start after headers
const headers = data[0]; // First row as column names
const newRows = data.slice(lastRowSent); // Get rows added since the last run
if (newRows.length > 0) {
// Send each row as a separate request
newRows.forEach(row => {
const payload = row.reduce((obj, value, index) => {
obj[headers[index]] = value || ''; // Map values to column names
return obj;
}, {});
const options = {
method: 'post',
contentType: 'application/json',
payload: JSON.stringify(payload),
};
UrlFetchApp.fetch(WEBHOOK_URL, options); // Send each row
});
// Update the last row sent
PropertiesService.getScriptProperties().setProperty('lastRowSent', data.length);
}
}
HTML
<!DOCTYPE html>
<html>
<head>
<base target="_top" />
</head>
<body>
<h3>Send Data to Clay</h3>
<label for="webhookUrl">Clay Webhook URL:</label><br />
<input type="text" id="webhookUrl" style="width: 100%;" /><br /><br />
<button onclick="sendData()">Send Data</button>
<p id="status"></p>
<script>
function sendData() {
const webhookUrl = document.getElementById('webhookUrl').value;
if (!webhookUrl) {
document.getElementById('status').innerText =
'Please enter a valid webhook URL!';
return;
}
google.script.run
.withSuccessHandler(response => {
document.getElementById('status').innerText = `Success: ${response}`;
})
.withFailureHandler(error => {
document.getElementById('status').innerText = `Error: ${error.message}`;
})
.sendDataToClayWebhook(webhookUrl);
}
</script>
</body>
</html>