HumationHuman + Automation
Back to Catalog

Sync Shopify customers to Google Sheets + Squarespace compatible csv

bangank36bangank36
622 views
2/3/2026
SupportJiraCustomer ServiceIntercomEscalation
Official Page

This workflow retrieves all Shopify Customers and saves them into a Google Sheets spreadsheet using the Shopify Admin REST API. It uses pagination to ensure all customers are collected efficiently.

N8n does not have built-in actions for Customers, so I built the workflow using an HTTP Request node.

How It Works

This workflow uses the HTTP Request node to fetch paginated chunks manually.

  • Shopify uses cursor-based pagination (page_info) instead of traditional page numbers.
  • Pagination data is stored in the response headers, so we need to enable Include Response Headers and Status in the HTTP Request node.
  • The workflow processes customer data, saves it to Google Sheets, and formats a compatible CSV for Squarespace Contacts import.
  • This workflow can be run on demand or scheduled to keep your data up to date.

Parameters

You can adjust these parameters in the HTTP Request node:

  • limit – The number of customers per request (default: 50, max: 250).
  • fields – Comma-separated list of fields to retrieve.
  • page_info – Used for pagination; only limit and fields are allowed when paginating.

📌 Note: When you query paginated chunks with page_info, only the limit and fields parameters are allowed.

Credentials

  • Shopify API Key – Required for authentication.
  • Google Sheets API credentials – Needed to insert data into the spreadsheet.

Google Sheets Template

Clone this spreadsheet:

📎 Google Sheets Template

According to Squarespace documentation, your spreadsheet can have up to three columns and must be arranged in this order (no header):

  1. Email Address
  2. First Name (optional)
  3. Last Name (optional)
  4. Shopify Customer ID (this field will be ignored)

Exporting a Compatible CSV for Squarespace Contacts

This workflow also generates a CSV file that can be imported into Squarespace Contacts.

How to Import the CSV to Squarespace:

  1. Open the Lists & Segments panel and click on your mailing list.
  2. Click Add Subscribers, then select Upload a list.
  3. Click Add a CSV file and select the file to import.
  4. Toggle These subscribers accept marketing to confirm permission.
  5. Preview your list, then click Import.

Who Is This For?

  • Shopify store owners who need to export all customers to Google Sheets.
  • Anyone looking for a flexible and scalable Shopify customers extraction solution.
  • Squarespace website owners who want to bulk-create their Contacts using CSV.

Explore More Templates
👉 Check out my other n8n templates

Sync Shopify Customers to Google Sheets (Squarespace Compatible CSV)

This n8n workflow automates the process of extracting customer data from Shopify, transforming it into a Squarespace-compatible CSV format, and then uploading it to a specified Google Sheet. This is particularly useful for merchants who need to migrate or synchronize customer lists between platforms or maintain a centralized customer database in Google Sheets.

What it does

  1. Triggers Manually or on Schedule: The workflow can be executed manually or set to run at scheduled intervals.
  2. Fetches Shopify Customer Data: It makes an HTTP request to the Shopify API to retrieve a list of all customers.
  3. Formats Customer Data: It processes the raw Shopify customer data, extracting relevant fields such as first name, last name, email, and address details.
  4. Generates Squarespace-Compatible CSV: It transforms the extracted customer data into a CSV format that is compatible with Squarespace's customer import requirements. This includes handling multiple address lines and ensuring correct column headers.
  5. Uploads to Google Sheets: The generated CSV data is then appended as new rows to a specified Google Sheet.

Prerequisites/Requirements

  • n8n Instance: A running instance of n8n.
  • Shopify Account: Access to a Shopify store with API credentials (API Key, API Password, Store Name).
  • Google Account: A Google account with access to Google Sheets.
  • Google Sheets Credential: An n8n credential for Google Sheets (OAuth2 recommended).
  • HTTP Request Credential: An n8n credential for the HTTP Request node (likely a "Header Auth" or "Basic Auth" for Shopify API).

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • HTTP Request (Shopify): Configure the "HTTP Request" node (Node ID: 19) with your Shopify API credentials. You'll typically need to set headers for X-Shopify-Access-Token with your API password and ensure the URL is correctly formed for your store (e.g., https://YOUR_STORE_NAME.myshopify.com/admin/api/2023-10/customers.json).
    • Google Sheets: Configure the "Google Sheets" node (Node ID: 18) with your Google account credentials.
  3. Specify Google Sheet: In the "Google Sheets" node (Node ID: 18), specify the Spreadsheet ID and Sheet Name where you want the customer data to be added.
  4. Review Code Node: The "Code" node (Node ID: 834) contains the logic for formatting the Shopify data into the Squarespace-compatible CSV structure. Review this code to ensure it aligns with your specific Squarespace import requirements or any custom fields you need.
  5. Configure Trigger:
    • Manual Trigger: Use the "When clicking ‘Execute workflow’" node (Node ID: 838) to run the workflow manually.
    • Schedule Trigger: Configure the "Schedule Trigger" node (Node ID: 839) to run the workflow automatically at your desired interval (e.g., daily, weekly).
  6. Activate Workflow: Once configured, activate the workflow.

Related Templates

Automated press pass verification & badge creation with QR codes & multi-channel distribution

🎫 Verified Press Pass Generator for Media Events Automate press credential verification and badge generation for journalists covering your events --- 📝 Description Streamline your event media management with this comprehensive press pass automation. When journalists apply for credentials, this workflow instantly validates their identity, verifies their media affiliation, generates professional digital badges with QR codes, and delivers everything via email—all within seconds. Perfect for conferences, product launches, trade shows, corporate events, and any occasion requiring verified media access. --- ✨ Key Features 🔐 Advanced Email Verification Real-time email validation using VerifiEmail API Checks RFC compliance, MX records, and domain reputation Detects disposable email addresses and spoofed domains Confirms journalist works for legitimate media organization 🎨 Professional Badge Design Auto-generates branded digital press passes Includes journalist photo, name, media outlet, and credentials Embedded QR code for contactless event entry Customizable colors, fonts, and event branding 400×600px portrait format optimized for mobile display 📧 Automated Communication Beautiful HTML email with embedded badge preview Download links for PNG and PDF versions Clear instructions for event check-in Professional event branding throughout 📊 Multi-Platform Logging Google Sheets backup with timestamp logs Slack notifications for organizer oversight Complete audit trail for compliance ⚡ Lightning Fast Processing Average execution time: 5-10 seconds Real-time webhook response with confirmation Scalable to hundreds of applications per hour Error handling with graceful fallbacks --- 🎯 Use Cases Event Types: Tech conferences and summits Product launch events Trade shows and exhibitions Political rallies and press conferences Sports events and tournaments Film festivals and premieres Corporate announcements Award ceremonies --- 🔧 What You Need Required Services: n8n (Cloud or Self-hosted) VerifiEmail API (Get API Key) - Email verification HTMLCSSToImage API (Get API Key) - Badge generation Gmail Account (OAuth) - Email delivery Slack Workspace - Team notifications Google Sheets - Backup logging --- 📋 How It Works Step-by-Step Process: Application Submission Journalist fills out form on your event website (name, email, media outlet, photo, phone) Data Validation Webhook receives application and checks for required fields (name, email, photo) Email Verification VerifiEmail API validates email domain, checks MX records, and confirms media affiliation Credential Generation Generates unique press ID (PRESS-XXX-timestamp) Creates QR code linking to verification portal Sets 30-day validity period Badge Creation HTMLCSSToImage API renders professional badge with: Circular profile photo Name and media outlet Press ID in styled container Scannable QR code Event name and validity dates "VERIFIED" indicator Distribution Sends HTML email with badge preview and download link Posts notification to Slack channel Backs up to Google Sheets Returns success response to webhook Event Check-In Security scans QR code at event entrance, verifies credentials instantly --- 🚀 Setup Instructions Quick Start (15 minutes): Import Workflow Download the JSON file In n8n: Click Workflows → Import from File Upload the JSON and open the workflow Configure Webhook Activate the workflow Copy the webhook URL from the Webhook Trigger node Add this URL to your website form's action attribute Add API Credentials VerifiEmail: Create credential with API key from verifi.email dashboard HTMLCSSToImage: Add User ID and API Key from htmlcsstoimg.com Gmail: Connect via OAuth (click "Sign in with Google") Slack: Connect via OAuth and select notification channel Google Sheets: Connect via OAuth Setup Google Sheets Create a new sheet named "Press Pass Logs" with these column headers: Timestamp | Press ID | Name | Email | Phone | Media Outlet | Email Domain | Verification Status | Event Name | Issued Date | Valid Until | Badge Image URL | QR Code URL | Verification URL | Photo URL | Execution Mode Customize Badge Design Open the "HTML/CSS to Image" node Edit the HTML in html_content field Change gradient colors: Replace 667eea and 764ba2 with your brand colors Update event name default value Modify font sizes, spacing, or layout as needed Update Email Content Open "Send Press Pass Email" node Customize email text, support contact info Update company/event branding Modify footer with your details Configure Slack Channel Open "Notify Organizers (Slack)" node Select your preferred notification channel Customize notification message format Test the Workflow Send a test POST request using Postman or cURL: bash curl -X POST https://your-n8n-url/webhook/press-application \ -H "Content-Type: application/json" \ -d '{ "name": "Jane Smith", "email": "jane@bbc.com", "media_outlet": "BBC News", "photo_url": "https://randomuser.me/api/portraits/women/50.jpg", "phone": "+44-1234567890", "event_name": "Tech Summit 2025" }' Go Live Verify test execution completed successfully Check email received with badge Activate workflow for production use --- 🎨 Customization Options Badge Design: Colors: Change gradient from purple (667eea, 764ba2) to your brand colors Fonts: Swap Google Font from Poppins to any available font Logo: Add event logo in header section Size: Adjust viewportwidth and viewportheight for different dimensions Layout: Modify HTML structure for custom badge designs Email Templates: Branding: Update colors, fonts, and styling in HTML email Content: Customize greeting, instructions, and footer Attachments: Add PDF version or additional documents Language: Translate all text to your language --- 🔒 Security & Privacy Data Protection: ✅ Email verification prevents fake submissions ✅ QR codes use unique, non-guessable IDs ✅ HTTPS webhook for encrypted transmission ✅ No sensitive data stored in workflow variables ✅ Audit trail for compliance requirements Best Practices: Use environment variables for API keys Enable webhook authentication (Basic Auth or API key) Implement rate limiting on webhook endpoint Regularly rotate API credentials Set up backup systems for critical data --- 🛠️ Troubleshooting Common Issues: Issue: "Webhook not receiving data" Solution: Ensure workflow is activated and webhook URL is correct in form action Issue: "Email verification fails for valid domains" Solution: Check VerifiEmail API credit balance and credential configuration Issue: "Badge image not generating" Solution: Verify HTMLCSSToImage API key is correct and has sufficient credits Issue: "Gmail not sending" Solution: Reconnect Gmail OAuth credential and check sending limits Issue: "QR code not loading in badge" Solution: Ensure QR code URL is properly encoded and publicly accessible --- 📈 Performance Metrics Average execution time: 5-10 seconds Success rate: 98%+ (with valid inputs) Concurrent capacity: 50+ requests/minute API reliability: 99.9% uptime (dependent on services) Badge generation: <2 seconds Email delivery: <3 seconds --- 🏷️ Tags event-management press-pass credential-verification badge-generation email-automation qr-code media-relations event-technology htmlcsstoimage verifi-email gmail slack google-sheets webhook automation workflow conference journalism press-credentials --- 📄 License This workflow template is provided as-is for use with n8n. Customize freely for your organization's needs. ---

Jitesh DugarBy Jitesh Dugar
362

Translate PDFs into multiple languages with Google Translate & ConvertAPI cost tracking

Description This n8n template automates PDF translation into 1 or 2 target languages while maintaining professional formatting. Users submit PDFs via web form and receive translated documents via email with preserved headings, paragraphs, and bullet points. Use Cases • International Business Contracts • Multilingual Product Documentation • Educational Content Distribution • Healthcare Patient Information for Diverse patient population • Marketing Campaign Materials What it does • Accepts PDF uploads via web form • Extracts and converts text to structured HTML • Translates using Google Translate API (20+ languages including Hindi, Telugu, Spanish, French, German, Chinese) • Converts to professional PDFs with ConvertAPI • Emails translated PDFs with cost breakdown • Tracks expenses in data table for analytics Set up • Configure Google Cloud Service Account (Translation API enabled) • Add ConvertAPI Query Auth credentials • Set up Gmail OAuth2 with send permissions • Create n8n Data Table named cost_tracking • Activate workflow and access form via webhook URL Requirements • Google Cloud account with Translation API • ConvertAPI account with credits • Gmail account for delivery • PDF files with selectable text (not scanned images) Customize • Edit CSS in "Prepare HTML" nodes for PDF styling • Update pricing in "Cost – Build record" node • Add languages in "Process Form Data" and form dropdown • Modify email template in Gmail nodes Support: Join n8n Discord or Community Forum

Sridevi EdupugantiBy Sridevi Edupuganti
106

Analyze call recordings with OpenAI and update Zoho CRM leads automatically

Zoho CRM - Conversation Intelligence Analyzer This workflow automatically processes customer call recordings, transcribes them using OpenAI Whisper, extracts key topics, identifies commitments, analyzes sentiment, generates follow-up suggestions and updates the corresponding Zoho CRM Lead — all without manual efforts. It eliminates the need for listening to calls or writing summaries and equips your sales team with instant AI-generated insights. ⚡ Quick Start (Fast Setup) Import the workflow JSON into n8n. Add Zoho CRM OAuth2 & OpenAI API credentials. Copy the webhook URL and configure your telephony system to POST call recordings. Map Zoho custom fields. Upload a test recording → Confirm CRM updates → Activate workflow. 📘 What It Does This workflow turns every incoming call recording into structured insights which your sales & customer support team can immediately use. When a recording is received, the call is automatically transcribed using OpenAI’s Whisper model. That transcript is then processed by multiple AI nodes that detect topics, customer sentiment, commitments and possible follow-up actions. All extracted data — such as mood, sentiment score, subjects, action items and commitments is merged into a clean result object and pushed to the matching Lead in Zoho CRM. The sales team gets ready-to-use call intelligence instantly, improving decision-making, accuracy and speed. This automation works 24/7 and replaces hours of manual review work with reliable AI-generated summaries. 👤 Who’s It For Sales & Customer support teams using Zoho CRM. Support teams handling inbound/outbound calls. Businesses wanting call analytics without manual transcription. Zoho CRM admins who want automation with minimal maintenance. Organizations using telephony/VoIP systems that support call exports. 🧾 Requirements To use this workflow, you need: An n8n instance (self-hosted or cloud) Zoho CRM OAuth2 credentials OpenAI API key (Whisper + GPT models) A telephony system capable of POSTing audio files to a webhook Zoho fields to store: Topics Main subject Action items Sentiment Mood Follow-up text Commitments (optional) ⚙️ How It Works & How to Set Up Webhook Trigger Your call system sends an audio file (.mp3, .wav, etc.) to the webhook. The workflow starts instantly—no polling required. Workflow Configuration Static values like: sentimentThreshold = 0.7 minCommitmentConfidence = 0.8 ensure consistent logic across nodes. Audio Transcription (OpenAI Whisper) The audio file is converted to text. This transcript becomes the base for all analysis nodes. Key Topic Extraction AI identifies: Key topics Main subject Important action items Sentiment & Mood Analysis AI analyzes: Customer mood Sales rep tone Overall sentiment Sentiment score Commitment Extraction AI detects commitments using a structured JSON schema. Follow-up Generation GPT generates 3–5 follow-up suggestions based on the transcript & commitments. Combine All Insights A Set node merges transcription, topics, sentiment, commitments and follow-up text. Update Zoho CRM Lead Updates Zoho custom fields so the sales team gets immediate insights. 🛠 How to Customize Nodes Transcription Node Switch to another Whisper/GPT model Add language options Topic Extraction Add more attributes (risks, objections, intent) Sentiment Analysis Tune thresholds Add more emotion labels Commitment Extraction Modify schema Add filtering logic CRM Update Map to different fields Append notes instead of overwriting ➕ Add-Ons (Optional Enhancements) Slack/Teams alerts for negative sentiment Email transcripts to teams Save files to Google Drive / S3 Create Zoho tasks from commitments Multi-language transcription Sales rep performance scoring 💼 Use Case Examples Sales Call Analysis – Auto-summarize calls for follow-up. Support Hotline Monitoring – Detect customer frustration. QA Audits – Auto-generate evaluation notes. Voice-to-CRM Logging – Store conversation data automatically. Compliance Tracking – Capture legally relevant commitments. 🛠 Troubleshooting Guide | Issue | Possible Cause | Solution | |------|----------------|----------| | Workflow not triggered | Telephony not hitting webhook | Recheck webhook URL & logs | | Transcript empty | Unsupported/corrupted audio | Validate file before sending | | CRM not updating | Wrong Zoho field IDs | Verify field IDs in Zoho | | Commitments missing | Transcript unclear | Improve audio quality or edit schema | | Sentiment inaccurate | Model interpretation | Adjust sentimentThreshold | 🤝 Need Help? If you want to customize this workflow, integrate telephony systems or want to build advanced level CRM automation, then our n8n workflow development team at WeblineIndia team is happy to help. We’re here to support setup, scaling, and custom enhancements.

WeblineIndiaBy WeblineIndia
259