Shopify New vs Returning Customer Revenue Report (n8n Template)

A ready-to-import n8n workflow that reports how much of your Shopify revenue comes from first-time versus repeat customers, every week, automatically.

  • Weekly Schedule Trigger pulls your paid orders from the Shopify Admin API
  • Splits orders into new and returning buyers and sums revenue for each
  • Appends the weekly summary to Google Sheets and emails it via Gmail
  • Six nodes, no code changes needed, works on n8n Cloud and self-hosted

Shopify Average Order Value Trend Report (n8n Template)

Ready-to-import n8n workflow that builds a weekly Shopify average order value (AOV) trend report. Pulls paid orders for the last seven days and the seven before, computes AOV for each window, logs the result to Google Sheets, and emails you the week-over-week change.

  • 6 core nodes, no paid apps required
  • Schedule trigger, two Shopify Admin API calls, a Code node for the math, Google Sheets append, Gmail send
  • Works on n8n Cloud and self-hosted
  • Credentials pre-placeholdered, active:false on import

Shopify Customer Lifetime Value Report (n8n Template)

Ready-to-import n8n template that ranks your Shopify customers by lifetime value every week, saves the full list to Google Sheets, and emails you the top spenders.

  • Weekly schedule trigger (runs every Monday)
  • Shopify Get All orders + revenue aggregation per customer
  • Top-20 ranking with average order value
  • Google Sheets append + formatted Gmail summary
  • Six nodes, no code to write, just add your three credentials

Shopify Inventory Valuation Report (n8n Template)

Import this n8n workflow to value your on-hand Shopify stock at cost automatically every week, no spreadsheet exports.

  • Queries your catalog through the Shopify GraphQL API in a single call
  • Values each variant at its unit cost and sums the on-hand total
  • Logs a dated row to Google Sheets so the figures build a trend
  • Emails you the headline number plus a count of variants with no cost set

Works on n8n Cloud and self-hosted. Just import the JSON and add your credentials.

AEO Content Gap Analyzer (n8n Template)

Ready-to-import n8n template that finds your AEO content gaps. Each week it asks Gemini (with Google Search grounding) your buyer questions, keeps only the ones where your brand is absent from both the answer and its sources, then makes a second AI call to draft a content brief for each gap. Gaps are logged to Google Sheets and emailed as a ranked opportunity list.

  • 9 nodes, all Code scripts included
  • Two-step AI: grounded analysis then brief generation
  • Outputs a content backlog with suggested titles and briefs
  • Works on n8n Cloud and self-hosted (v1.0 or newer); credentials are placeholders

AI Citation Monitor (n8n Template)

Ready-to-import n8n template that tracks whether AI answers cite your website. Each week it sends buyer questions to Gemini with Google Search grounding, reads the source list behind each answer, records whether your domain and competitor domains are cited, logs results to Google Sheets, and emails a citation report.

  • 7 nodes, all Code scripts included
  • Uses Gemini grounded search to get real source URLs
  • Tracks your domain + competitor domains, with a most-cited-domains tally
  • Works on n8n Cloud and self-hosted (v1.0 or newer); credentials are placeholders

Competitor AI-Visibility Monitor (n8n Template)

Ready-to-import n8n template that ranks your brand against competitors inside AI assistants. Each week it sends buyer-style prompts to Gemini and ChatGPT, scores every brand by mentions and order of appearance, logs a leaderboard snapshot to Google Sheets, and emails you the standings.

  • 8 nodes, all Code scripts included
  • Queries Gemini and ChatGPT via their official APIs
  • Ranks you + unlimited competitors by mention rate and average position
  • Works on n8n Cloud and self-hosted (v1.0 or newer); credentials are placeholders

AI Visibility Tracker for ChatGPT & Gemini (n8n Template)

Ready-to-import n8n template that tracks your brand visibility inside AI assistants. Each week it sends buyer-style prompts to Gemini and ChatGPT, records whether your brand and competitors are mentioned, logs every result to Google Sheets, and emails you a share-of-voice report.

  • 8 nodes, all Code scripts included
  • Queries Gemini and ChatGPT via their official APIs
  • Works on n8n Cloud and self-hosted (v1.0 or newer)
  • Credentials are placeholders: import, add your keys, edit your brand and prompts, activate

Shopify Dead Stock Report (n8n Template)

Ready-to-import n8n template that builds a weekly Shopify dead stock report: it flags every product variant that still holds inventory but sold nothing in the last 60 days, ranks them by the capital tied up, logs them to Google Sheets, and emails you a digest.

  • 7 nodes, both Code scripts included, no external apps required
  • Works on n8n Cloud and self-hosted (v1.0 or newer)
  • Connects Shopify, Google Sheets, and Gmail
  • Credentials are placeholders: import, connect your accounts, activate

Shopify SEO Meta Description Generator (n8n Template)

Ready-to-import n8n template that reads every Shopify product, writes an SEO meta title and meta description with Google Gemini, and saves them to native Shopify SEO fields.

  • Weekly schedule trigger, runs hands-free
  • Fetches products from the Shopify Admin API (2026-04)
  • Google Gemini (gemini-2.5-flash) writes the meta title and description
  • Writes back to global.title_tag and global.description_tag in one call
  • Six nodes, wired and ready. Add two credentials and your store URL.