This template downloads a public CSV from a URL you set, parses the rows in JavaScript, and writes them to a Google Sheets tab.
Use a schedule so the sheet stays current. Connect Google Sheets and paste the CSV URL on the HTTP request. Filter in JavaScript if you only want some rows.
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
A schedule starts the run on the cadence you set.
An HTTP request fetches the public CSV from the URL you paste.
JavaScript turns the file into rows and keeps the columns you map to the sheet.
Google Sheets receives the parsed rows in the tab you choose.
Add a Google Sheets connection. Pick the spreadsheet and tab that should receive the CSV rows.
Add an HTTP request and paste the public CSV URL. Use GET.
Parse the CSV in JavaScript, map columns to the sheet, then add the rows. Set a schedule so the tab refreshes. Run once and confirm the sheet.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
