Lead Sync from Google Sheets to Instantly Campaigns - n8n Workflow

• Sales teams and SDRs managing large lead lists.


• Marketing professionals running cold outreach campaigns via Instantly.


• Users looking for robust, scalable n8n templates for data synchronization.


• Anyone needing a reliable n8n workflow to handle lead status tracking before API submission.

Managing lead status across multiple platforms can be challenging. This powerful n8n workflow solves this by providing a unified approach to lead intake and campaign enrollment. By fetching data from Google Sheets, the automation first standardizes and stores the records within an n8n Data Table, which acts as the central source of truth.

This structure ensures that the Instantly platform only receives leads with the specific status (campaign = "start"), preventing costly duplicates and API errors. This robust n8n node configuration, combined with smart batching, makes this one of the most reliable n8n templates for high-volume lead operations. The entire n8n workflow is designed for scalability and rate-limit compliance, providing a crucial bridge between your raw data and your cold email platform.

This n8n workflow operates in two distinct, scheduled phases:

Phase 1: Data Standardization (Manual or Scheduled)

1. Start: The process begins using the Manual n8n trigger (or can be adapted to a Schedule trigger).


2. Google Sheets Intake: The Google Sheets n8n node retrieves all specified rows from the configured spreadsheet.


3. Batch Processing: The Loop Over Items n8n node splits the retrieved list into batches of 30 items. This critical step respects API rate limits during the update process.


4. Data Table Update (Enrichment): The n8n Data Table node updates the local lead records, transferring fields like Title into the focusarea column, ensuring the Data Table is current and contains standardized data. The n8n workflow then loops back until all batches are processed.

Phase 2: Instantly Sync (Scheduled)

1. Schedule Trigger: A dedicated Schedule n8n trigger initiates this flow periodically (e.g., hourly).


2. Filter New Leads: The first Data Table n8n node retrieves only leads where the campaign status is set to "start", ensuring only new leads are targeted for cold outreach.


3. Individual Processing: The second Loop Over Items1 n8n node processes these qualified leads individually (batch size 1 is standard for the Instantly API).


4. Instantly Enrollment: The Instantly n8n node creates a new lead in the designated Instantly campaign (e.g., "Launchday 1"), mapping necessary fields like Email, Firstname, and Website.


5. Status Update: The final n8n Data Table node updates the lead's status in the Data Table to "added to instantly". This status update is crucial, as it prevents this specific lead from being processed again on subsequent runs of this n8n workflow. This robust logic makes this a highly effective n8n template.

To deploy this expert n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Google Sheets Credentials: Create or select an existing Google Sheets OAuth2 credential. Ensure the service account has read access to your specific spreadsheet.


3. Instantly Credentials: Obtain your Instantly API key from their platform and set up the Instantly API credential within n8n.


4. Data Table Setup: Manually create a new n8n Data Table named Leads. It must include columns for Firstname, Email, Website, company, title, campaign, and focusarea (all string types).


5. Configure Nodes:

1. Activate: Save and activate the n8n workflow. Use the Manual Trigger for an initial test, then rely on the Schedule Trigger for continuous, hands-off automation.

This n8n workflow utilizes several specialized and core n8n node types to achieve robust data flow management:

When clicking 'Execute workflow' (Manual Trigger n8n trigger): Initiates the Google Sheets data ingestion pipeline upon manual execution. This is helpful for testing or large initial data imports.
Schedule Trigger (n8n trigger): Automatically starts the Instantly sync flow on a recurring basis, ensuring leads are enrolled promptly.
Get row(s) in sheet (Google Sheets n8n node): Fetches all records from the source Google Sheet. It is configured to pull data from the sheet named 'instantly leads' in the configured document.
Loop Over Items / Loop Over Items1 (Split In Batches n8n node): Essential flow control n8n nodes. The first loop handles batching of 30 items for the Data Table update, respecting API limits. The second loop ensures individual processing for the Instantly API calls.
Update row(s)1 (Data Table n8n node): Used in the initial flow to upload/update lead records from Google Sheets into the local 'Leads' Data Table. It maps the incoming Title field to the focusarea column.
Get row(s) (Data Table n8n node): This crucial n8n node filters the Leads table, only retrieving records where the campaign status equals "start". This ensures only leads qualified for outreach proceed to the next step.
Create a lead (Instantly n8n node): The core action n8n node. It sends the filtered lead data (Email, Firstname, Company, Website) to the specific 'Launchday 1' Instantly campaign.
Update row(s) (Data Table n8n node): After successful Instantly enrollment, this n8n node updates the campaign column for that specific lead to "added to instantly", effectively marking it as processed and preventing re-enrollment.