This template watches a Google Sheet for new or changed rows, maps the columns in JavaScript, and writes the matching record in Knack.
Find the Knack object by your key field, then update it, or create a record when none exists. Connect Google Sheets and Knack. Put the Knack API key on the Knack connection.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when a row is added or updated in the Google Sheet you choose.
JavaScript turns sheet columns into Knack fields.
Knack finds the record by your key field and updates it, or creates a record when none exists.
Add a Google Sheets connection. Watch new or updated rows on the worksheet you keep as the source.
Add a Knack connection for the app and object that should receive those rows. Put the Knack API key on that connection.
In JavaScript, map sheet columns onto Knack fields. Find the record by your key, then update or create. Add a test row and confirm Knack.
FAQ
More templates
This template runs on a schedule, opens each URL in a headless browser, and compares visible text to the last snapshot in Latenode Database. When the change crosses your threshold, JavaScript builds RSS XML and Google Drive saves the feed file. Connect Google Drive. Keep snapshots in Latenode Database keyed by URL.
This template receives Cognito Forms submissions on a Latenode webhook, maps the payload, then creates or updates the contact in ActiveCampaign and applies a tag. Paste the webhook URL into Cognito Forms. Connect ActiveCampaign and put the API URL and key on that connection. Map email so matches update the same person.
This template watches a Discord channel for new messages, translates the text with Google Cloud Translate, and posts the translation back to Discord. Connect a Discord bot and Google Cloud Translate. Put the Translate API key on the Google Cloud Translate connection. Point the trigger at the channel you want to translate and pick the target language.
