Latenode
Google Sheets
JavaScript

Sync Two Google Sheets Automatically with Latenode

This template copies new rows from a source Google Sheet into a destination sheet. A new-row trigger starts the run.

JavaScript maps the columns you care about. Google Sheets appends the row. Connect Google Sheets once with access to both files. Point the trigger at the source tab, then point the append at the destination tab.

Updated Sep 16, 2026Est. run: 4sEst. cost: $0.0003
How Latenode estimates time and cost

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

What this template does

  • Copies new source rows into a second Google Sheet
  • Maps columns in JavaScript so headers can differ
  • Appends one destination row per new source row
  • Can skip a key that already exists on the destination

How it works

1
Trigger

Watch the source sheet

The scenario starts when a new row appears in the source Google Sheet.

2
Logic

Map the columns

JavaScript copies the source fields into the destination column order.

3
Action

Append the destination row

Google Sheets adds that row on the second spreadsheet. Search by a key column first if you want to skip a row you already copied.

Setup guide

1

Connect Google Sheets

Add a Google Sheets connection with access to both the source spreadsheet and the destination spreadsheet.

2

Point the trigger at the source

Watch new rows on the source tab. Note the column letters you will copy.

3

Map and append

In JavaScript, line up source columns with destination headers, then add a single row on the destination tab. Search the destination by a key first if you skip repeats.

4

Test with one row

Add a sample row on the source sheet and confirm it appears on the destination with the mapped columns.

Requirements

A source Google Sheet Latenode can read
A destination Google Sheet Latenode can append to
Agreement on which source columns map to which destination headers

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →

123FormBuilder to Insightly: Create leads from form submissions

Manually copying form responses into your CRM wastes time and risks errors. This integration captures each New Submission event from 123FormBuilder and uses it to Create a Lead in Insightly, mapping the respondent's name, email, and custom fields directly into a new lead record. Marketing managers and sales teams can eliminate data entry and get leads into Insightly instantly for follow-up. By connecting 123FormBuilder's form capture with Insightly's CRM, you keep your sales pipeline fed without manual work.

8s~$0.002

Create a Pipeline deal from a new Discord channel message

Sales teams often miss leads buried in Discord conversations. This scenario captures every new message in a chosen Discord channel and creates a corresponding deal in Pipeline, using the message text as the deal description and the author's username as part of the deal name. Sales managers and business development reps can log inbound signals from team discussions directly into Pipeline CRM without manual data entry. The connection turns Discord into a lead source, so no opportunity slips through the cracks.

8s~$0.002

Create a Pipeline deal when a new HubSpot deal is added

Manually copying deal data from HubSpot to Pipeline wastes time and risks errors. This automation triggers on the New Deal event in HubSpot and then runs the Create Deal action in Pipeline, mapping the deal name, amount, and associated contact email and name. Sales operations teams and CRM administrators who use both HubSpot and Pipeline can eliminate duplicate data entry. HubSpot captures the initial deal, and Pipeline receives a matching record immediately, so both systems stay aligned without manual work.

8s~$0.002