Sync Canada New Incorporations to Google Sheets with n8n

Auto-sync new Canadian company incorporations into Google Sheets (via n8n)

This n8n workflow checks Apify daily for newly registered Canadian companies and automatically appends the latest incorporation records into your Google Sheets tab—so your CRM, lead list, or research sheet stays current without manual work.

What this workflow does

• Runs on a schedule: the workflow is configured to execute every day at 8am.
• Fetches new incorporations from Apify: it calls the Apify API to run the actor truenorthdata/canada-new-incorporations and retrieves companies incorporated within the last 3 days.
• Pulls net-new results: the actor/API request is limited to new (net-new) results since the last run, helping prevent duplicate rows.
• Appends results to Google Sheets: each returned incorporation record is written as a new row into a specified spreadsheet tab.

Use cases

• Lead generation and prospecting: keep a running list of newly incorporated Canadian businesses for sales outreach.
• Market research: track incorporation trends by date and capture fresh data points daily.
• Operations and compliance workflows: monitor new registrations to support onboarding, vendor discovery, or data enrichment pipelines.
• Automation engineering: use it as a reliable template for scheduled Apify-to-Google Sheets syncing.

Technical details

• Schedule Trigger: runs daily at 8am.
• HTTP Request node: calls the Apify API (you’ll replace YOUR_APIFY_API_TOKEN).
• Google Sheets node: appends incorporation records to your target sheet/tab (set YOUR_GOOGLE_SHEET_ID).
• Field alignment: verify your Google Sheet columns match the Apify dataset fields, or use auto-mapping to maintain a consistent row shape.
• Nodes referenced in the workflow: sticky note, http request, google sheets, schedule trigger.

Setup

• Create an Apify account, generate an API token, and update the workflow request with YOUR_APIFY_API_TOKEN.
• Connect Google Sheets, set YOUR_GOOGLE_SHEET_ID, and choose the sheet/tab name.
• Confirm column compatibility with the Apify dataset (or use auto-mapping), then activate the workflow.