Shopify Customers to Google Sheets

Name: Shopify Customers to Google Sheets
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

49 views

0 downloads

E-commerceautomationcustomersdata exportgoogle sheetsshopifysync

Sync Shopify customer data to a Google Sheet.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow retrieves customer data from Shopify and appends or updates it in a Google Sheet. It handles pagination to ensure all customers are synced and can convert the data into a CSV format for Squarespace contact imports.

Key Features

Fetches Shopify customer data.
Handles pagination for complete data retrieval.
Appends or updates customer information in a Google Sheet.
Option to convert data to CSV format.

How To Use

Configure Shopify credentials.
Configure Google Sheets credentials.
Set the SHOPIFY_URL environment variable with your Shopify store URL.
Set the WEBHOOK_URL environment variable (if using the Squarespace CSV conversion).
Adjust the Google Sheet's sheetName and documentId to match your target spreadsheet.
The workflow can be triggered manually or via a schedule.

Apps Used

automation

customers

data export

google sheets

shopify

sync

Workflow JSON

{
  "id": "848e2f44-a923-4442-a2a0-b2aae3ed7127",
  "name": "Shopify Customers to Google Sheets",
  "nodes": 0,
  "category": "E-commerce",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.