January 22, 2026

Amazon to Google Sheets, ad angles your team can use

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Pulling competitor reviews is easy. Turning them into ads that actually convert is the part that drags, because you’re stuck copying snippets, sorting them, and trying to spot patterns with tired eyes. Amazon review automation fixes that by turning messy review text into something your team can use the same day.

This hits media buyers hardest when they need fresh angles by 3pm. But ecommerce founders and growth marketers feel it too, because “we should test new hooks” turns into a week of tab-juggling. The outcome here is simple: a clean brief plus a ready-to-run creative delivered to your inbox.

You’ll see how this workflow collects Amazon reviews, saves them to Google Sheets, summarizes competitor weaknesses with OpenAI, generates a 1080×1080 ad image, then emails the package via Gmail.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Amazon to Google Sheets, ad angles your team can use

Click to explore

flowchart LR

    subgraph sg0["On form submission - Amazon Reviews Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Snapshot Progress"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>HTTP Request- Post API call .."]
        n2@{ icon: "mdi:cog", form: "rounded", label: "Wait - Polling Bright Data", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If - Checking status of Snap..", pos: "b", h: 48 }
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>HTTP Request - Getting data .."]
        n5@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n6@{ icon: "mdi:database", form: "rounded", label: "Google Sheets - Adding All R..", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>On form submission - Amazon .."]
        n8@{ icon: "mdi:cog", form: "rounded", label: "Aggregating all reviews", pos: "b", h: 48 }
        n9@{ icon: "mdi:robot", form: "rounded", label: "Basic LLM Chain - Summary of..", pos: "b", h: 48 }
        n10@{ icon: "mdi:robot", form: "rounded", label: "OpenAI- Generating image", pos: "b", h: 48 }
        n11@{ icon: "mdi:message-outline", form: "rounded", label: "Gmail - Sending creative to ..", pos: "b", h: 48 }
        n5 -.-> n9
        n0 --> n3
        n8 --> n9
        n10 --> n11
        n2 --> n0
        n6 --> n8
        n7 --> n1
        n1 --> n2
        n9 --> n10
        n4 --> n6
        n3 --> n2
        n3 --> n4
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n7 trigger
    class n9,n10 ai
    class n5 aiModel
    class n3 decision
    class n6 database
    class n0,n1,n4 api
    classDef customIcon fill:none,stroke:none
    class n0,n1,n4,n7 customIcon

The Challenge: Turning messy reviews into usable ad angles

You find a competitor on Amazon and think, “Perfect. Reviews will tell us what to say.” Then reality shows up. The reviews are scattered across pages, the best quotes are buried, and the “why people hate this” themes don’t jump out until you’ve wasted a chunk of your afternoon. Next you paste everything into a doc, lose formatting, and someone on the team asks for “just one more competitor” right when you thought you were done. Frankly, it’s the kind of work that feels productive but rarely ships ads.

It adds up fast. Here’s where it breaks down in real teams.

Copying reviews by hand usually turns into an hour of scrolling, pasting, and “wait, did we already grab this one?”
Patterns get missed because you’re reading 200 opinions with no aggregation, so “lid leaks” shows up 12 times and still doesn’t feel obvious.
Ad angle brainstorms become subjective debates, because there’s no consistent summary of competitor weaknesses to anchor the room.
Creative production starts late since the insights live in a sheet, the brief lives in Slack, and the image request lives “in someone’s head.”

The Fix: Amazon reviews to ad-ready briefs (and a creative)

This workflow starts with one simple input: an Amazon product URL (your competitor). When you submit it through the built-in form, n8n triggers a Bright Data scraping job to collect the reviews for that listing. The workflow then waits and checks progress until the scrape snapshot is complete, pulls the results as JSON, and appends the raw review content into a Google Sheet so you have a clean, searchable archive. After that, it combines the text into a single body of feedback and asks OpenAI (GPT-4o mini by default) to summarize the competitor’s main weaknesses in plain language your ad team can act on. Finally, it generates a 1080×1080 creative image based on those pain points and emails both the brief and the creative to your team via Gmail.

The workflow begins with a form submission and a single URL. Bright Data gathers the review data, and OpenAI turns that raw feedback into a concise “what’s broken and what to say instead” summary. Gmail delivers the finished package so it’s immediately usable.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Manual review scraping, copy-paste sessions, and duplicate grabbing.
Sorting raw text into “themes” by hand inside docs or Slack threads.
Waiting on someone to write a brief after the research is “done.”
Separate handoffs for insight summary, creative request, and delivery.

Most teams get a usable brief in about 20–40 minutes instead of half a day.
Competitor weaknesses show up as clear, testable hooks rather than vague notes.
Google Sheets becomes your running library of competitor review intel.
Your media buying team gets the brief and image in one email, ready to plug into a Meta test.
It’s easier to run this weekly, because the workflow does the repetitive part for you.

Real-World Impact

Say you analyze 5 competitor products per week. Manually, you might spend about 45 minutes scraping reviews per product, then another 45 minutes turning notes into something ad-worthy, which is roughly 7–8 hours weekly. With this workflow, submitting each URL takes a minute or two, then you wait for the scrape and generation (often around 30 minutes total per product, mostly hands-off). That’s about 5 hours back in a typical week, while still ending up with a brief and a creative.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store the scraped reviews.
Bright Data for Amazon review scraping snapshots.
OpenAI API key (get it from your OpenAI dashboard).
Gmail to email the brief and creative.

Skill level: Intermediate. You’ll connect accounts, add API keys, and tweak prompts, but you won’t be writing code.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

Form submission with the competitor URL. You paste an Amazon product link into the form, which triggers the workflow instantly (or on a schedule if you decide to add one later).

Review scraping and progress checks. n8n starts a Bright Data job, pauses for a short delay, then polls snapshot status until it’s ready. No babysitting, just a controlled “check, wait, check again” loop.

Review data gets stored and consolidated. The workflow fetches the JSON results, appends the reviews into Google Sheets, and aggregates the text into one combined input that’s easier for an AI model to analyze.

OpenAI creates the deliverables. First you get a tight competitor weakness summary (your brief). Then an image is generated at 1080×1080 to match the ad angle. Gmail sends both to the people who actually launch campaigns.

You can easily modify the prompt and the email recipients to match your brand voice and your team structure. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

This workflow starts when a user submits a product URL through a form.

Add the Form Intake for Product URL node as the trigger.
Set Form Title to Please Paste The URL of the Amazon Product.
In Form Fields, add a field labeled Amazon Product URL and set the placeholder to https://www.amazon.com/Quencher-Cupholder-Compatible-Insulated-Stainless/dp/B0DCDQ1RFV.

Share the form URL with your team so they can submit new product URLs without accessing n8n.

Step 2: Connect Bright Data Job Triggering and Polling

These nodes trigger the Bright Data scrape, then poll until results are ready.

Open Trigger Bright Data Job and set URL to https://api.brightdata.com/datasets/v3/trigger.
Set Method to POST and JSON Body to =[{ "url": "{{ $json['Amazon Product URL'] }}" }].
In Query Parameters, set dataset_id to [YOUR_ID] and include_errors to true.
In Headers, set Authorization to [CONFIGURE_YOUR_TOKEN].
Configure Delay for Data Polling with Unit set to minutes and Amount set to 1.
Set Check Snapshot Progress URL to =https://api.brightdata.com/datasets/v3/progress/{{ $('Trigger Bright Data Job').item.json.snapshot_id }} and include the same Authorization header.
In Snapshot Status Gate, set the condition Left Value to {{ $json.status }}, Operator to equals, and Right Value to running.
Configure Fetch Snapshot Results with URL set to =https://api.brightdata.com/datasets/v3/snapshot/{{ $('Trigger Bright Data Job').item.json.snapshot_id }}, add Query Parameters format = json, and include the same Authorization header.

⚠️ Common Pitfall: If the Bright Data token or dataset ID is incorrect, Snapshot Status Gate will keep looping and no results will be fetched.

Step 3: Connect Google Sheets and Aggregate Reviews

The workflow appends snapshot data to Google Sheets and combines all review text for summarization.

Open Append Reviews to Sheet and set Operation to append.
Select the Document ID value [YOUR_ID] and the Sheet Name value gid=0.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
In Combine Review Text, set Field To Aggregate to review_text and Output Field Name to Aggregated_reviews.

Step 4: Set Up LLM Summarization and Image Generation

These nodes summarize competitor weaknesses and generate a creative image using OpenAI.

Open OpenAI Chat Engine and select the model gpt-4o-mini.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine.
In LLM Review Summary, set Prompt Type to define and Text to =Read the following reviews, these are reviews of our competitors: {{ $json.Aggregated_reviews }} --- After reading them, summarize their weakest points. Don't mention the competitor name..
Confirm OpenAI Chat Engine is connected as the language model for LLM Review Summary (credentials should be added to OpenAI Chat Engine, not the sub-node).
In Generate Creative Image, set Resource to image and Prompt to the full JSON prompt: ={ "ad_dimensions": { "width": 1080, "height": 1080 }, "target_audience": "B2C customer", "pain_points_source": "choose one pain point based on this {{ $json.text }}", "ad_requirements": { "image_style": "weird-and-fun", "weird_objects": [ "Fruit with Faces", "Realistic People" ], "focus": "address the biggest pain point of competitors", "avoid_naming_competitors": true, "headline": { "position": "No", "text_only": "No", "other_text": "No" }, "background": [ "bold red", "black" ] } }.
Credential Required: Connect your openAiApi credentials in Generate Creative Image.

If image generation fails, reduce the prompt complexity or confirm your OpenAI image model supports JSON-based prompts.

Step 5: Configure the Email Output

The final step emails the summary and generated image to your inbox.

Open Email Creative Brief and set Send To to [YOUR_EMAIL].
Set Subject to =Static Creatives Based on Our competitor {{ $now }}.
Set Message to =Hey, We have analyzed our competitors recent reviews. Analysis data: {{ $today }} Here's a summary: {{ $('LLM Review Summary').item.json.text }} Please see attached an AI generated 1080x1080 image which you can use in Meta ads..
Credential Required: Connect your gmailOAuth2 credentials.

Step 6: Test and Activate Your Workflow

Run a full test to verify the scrape, summary, image creation, and email delivery.

Click Execute Workflow and submit a test URL through Form Intake for Product URL.
Verify Trigger Bright Data Job returns a snapshot ID and that Snapshot Status Gate loops until the status changes.
Confirm rows are appended in the Google Sheet by Append Reviews to Sheet.
Check that LLM Review Summary outputs a summary and Generate Creative Image returns an image.
Ensure Email Creative Brief delivers an email with the summary and attached image.
Turn on the workflow using the Active toggle for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

Bright Data credentials can expire or need specific permissions. If things break, check your Bright Data workspace API key and dataset access first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Common Questions

How quickly can I implement this Amazon review automation automation?

About 30–60 minutes if your accounts and API keys are ready.

Can non-technical teams implement this Amazon review automation?

Yes. You’ll connect tools, paste API keys, and test the form once.

Is n8n free to use for this Amazon review automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often just a few cents per run) and Bright Data scraping costs based on usage.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this Amazon review automation solution to my specific challenges?

You can swap the prompt inside the LLM Review Summary to match your offer, your compliance rules, and your brand voice. Many teams also adjust the Google Sheets columns in Append Reviews to Sheet so they can tag reviews by theme (shipping, quality, sizing) or by rating. If you prefer a different model, change the OpenAI Chat Engine model setting and keep the rest of the workflow the same. And if you already have a design system, replace Generate Creative Image with a “send to designer” email while keeping the automated brief.

Why is my Google Sheets connection failing in this workflow?

Usually it’s an expired Google authorization or the wrong spreadsheet access. Reconnect Google Sheets in n8n credentials, then confirm the target Sheet ID and tab name still exist. If someone duplicated the template and deleted the original tab, the append step will fail even though your login is fine.

What’s the capacity of this Amazon review automation solution?

On n8n Cloud, capacity depends on your plan’s monthly executions, and self-hosting mainly depends on your server. Practically, this workflow can handle many competitor URLs per day, but Bright Data snapshot time and OpenAI generation time become the limiting factors. If you want high volume, run it on a schedule and stagger submissions so you’re not polling dozens of snapshots at once.

Is this Amazon review automation automation better than using Zapier or Make?

Often, yes, because this flow needs waiting, polling, and branching logic (snapshot not ready yet? wait and check again) and n8n handles that cleanly. The Google Sheets + Gmail integration is straightforward in any tool, but the HTTP requests and control flow usually get clunky or pricey elsewhere. n8n also gives you the option to self-host, which matters when you want to run lots of research without counting every task. Zapier or Make can still be fine for a lightweight version if you skip the scraping loop and only process data you already have. If you’re unsure, Talk to an automation expert and we’ll sanity-check your use case.

This is what “research” looks like when it actually feeds production. Set it up once, and every competitor URL turns into a brief and a creative your team can act on.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "Automated Review Insight Pipeline",
"meta": {
"instanceId": "878d94c732c6eef84cd3483ea353d4b1849fc5987ecef22f79d193778906a2d4",
"templateId": "",
"templateCredsSetupCompleted": ""
},
"versionId": null,
"nodes": [
{
"id": "flowpast-topbar-3624",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
25,
75
],
"parameters": {
"color": 7,
"width": 975,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "d2aa5abc-6a8b-4ad3-9b87-1349f3dd80b9",
"name": "Check Snapshot Progress",
"type": "n8n-nodes-base.httpRequest",
"position": [
165,
200
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $('Trigger Bright Data Job').item.json.snapshot_id }}",
"options": [],
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d6a75b46-e968-4dab-962d-1f81b643b768",
"name": "Trigger Bright Data Job",
"type": "n8n-nodes-base.httpRequest",
"position": [
575,
250
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": [],
"jsonBody": "=[\n  {\n    \"url\": \"{{ $json['Amazon Product URL'] }}\"\n  }\n]",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "[YOUR_ID]"
},
{
"name": "include_errors",
"value": "true"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "50a6c73a-dd82-40af-ad5a-88ef4fd5fc7c",
"name": "Delay for Data Polling",
"type": "n8n-nodes-base.wait",
"position": [
440,
220
],
"webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
"parameters": {
"unit": "minutes",
"amount": 1
},
"executeOnce": false,
"typeVersion": 1.1
},
{
"id": "8af8f713-6d5d-4113-ad5e-86b29fc8f441",
"name": "Snapshot Status Gate",
"type": "n8n-nodes-base.if",
"position": [
25,
235
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7932282b-71bb-4bbb-ab73-4978e554de7e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "running"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "98166378-3766-4c69-b891-48891a18e175",
"name": "Fetch Snapshot Results",
"type": "n8n-nodes-base.httpRequest",
"position": [
30,
400
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $('Trigger Bright Data Job').item.json.snapshot_id }}",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "5fd57531-25f4-4b10-9d95-bbeda1b336cf",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
705,
415
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "413669e5-2b75-499d-ba00-766b3cce0d69",
"name": "Append Reviews to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
255,
410
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_name",
"type": "string",
"display": true,
"required": false,
"displayName": "product_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_rating",
"type": "string",
"display": true,
"required": false,
"displayName": "product_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_rating_object",
"type": "string",
"display": true,
"required": false,
"displayName": "product_rating_object",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_rating_max",
"type": "string",
"display": true,
"required": false,
"displayName": "product_rating_max",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author_name",
"type": "string",
"display": true,
"required": false,
"displayName": "author_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "asin",
"type": "string",
"display": true,
"required": false,
"displayName": "asin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_rating_count",
"type": "string",
"display": true,
"required": false,
"displayName": "product_rating_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_header",
"type": "string",
"display": true,
"required": false,
"displayName": "review_header",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_id",
"type": "string",
"display": true,
"required": false,
"displayName": "review_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_text",
"type": "string",
"display": true,
"required": false,
"displayName": "review_text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author_id",
"type": "string",
"display": true,
"required": false,
"displayName": "author_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author_link",
"type": "string",
"display": true,
"required": false,
"displayName": "author_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "badge",
"type": "string",
"display": true,
"required": false,
"displayName": "badge",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "brand",
"type": "string",
"display": true,
"required": false,
"displayName": "brand",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_posted_date",
"type": "string",
"display": true,
"required": false,
"displayName": "review_posted_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_country",
"type": "string",
"display": true,
"required": false,
"displayName": "review_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_images",
"type": "string",
"display": true,
"required": false,
"displayName": "review_images",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "helpful_count",
"type": "string",
"display": true,
"required": false,
"displayName": "helpful_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_amazon_vine",
"type": "string",
"display": true,
"required": false,
"displayName": "is_amazon_vine",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_verified",
"type": "string",
"display": true,
"required": false,
"displayName": "is_verified",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variant_asin",
"type": "string",
"display": true,
"required": false,
"displayName": "variant_asin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variant_name",
"type": "string",
"display": true,
"required": false,
"displayName": "variant_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videos",
"type": "string",
"display": true,
"required": false,
"displayName": "videos",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "NoFluff-N8N-Sheet-Template- AMAZON Reviews Scraping WIth Bright Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "e1d58479-4008-4801-8523-fa2304ea9ef0",
"name": "Form Intake for Product URL",
"type": "n8n-nodes-base.formTrigger",
"position": [
830,
175
],
"webhookId": "8d0269c7-d1fc-45a1-a411-19634a1e0b82",
"parameters": {
"options": [],
"formTitle": "Please Paste The URL of the Amazon Product",
"formFields": {
"values": [
{
"fieldLabel": "Amazon Product URL",
"placeholder": "https://www.amazon.com/Quencher-Cupholder-Compatible-Insulated-Stainless/dp/B0DCDQ1RFV",
"requiredField": true
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2d79e9d2-a867-447e-91f9-b90c2e56427a",
"name": "Combine Review Text",
"type": "n8n-nodes-base.aggregate",
"position": [
410,
455
],
"parameters": {
"options": [],
"fieldsToAggregate": {
"fieldToAggregate": [
{
"renameField": true,
"outputFieldName": "Aggregated_reviews",
"fieldToAggregate": "review_text"
}
]
}
},
"typeVersion": 1
},
{
"id": "937ef1c4-32b3-4966-abb4-f4ae09aa12a7",
"name": "LLM Review Summary",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
840,
450
],
"parameters": {
"text": "=Read the following reviews, these are reviews of our competitors:\n{{ $json.Aggregated_reviews }}\n\n---\nAfter reading them, summarize their weakest points.\nDon't mention the competitor name.\n\n",
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "2ccf1e0f-a738-44ee-bd8f-65a02a92ca91",
"name": "Generate Creative Image",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
900,
625
],
"parameters": {
"prompt": "={\n  \"ad_dimensions\": {\n    \"width\": 1080,\n    \"height\": 1080\n  },\n  \"target_audience\": \"B2C customer\",\n  \"pain_points_source\": \"choose one pain point based on this {{ $json.text }}\",\n  \"ad_requirements\": {\n    \"image_style\": \"weird-and-fun\",\n    \"weird_objects\": [\n      \"Fruit with Faces\",\n      \"Realistic People\"\n    ],\n    \"focus\": \"address the biggest pain point of competitors\",\n    \"avoid_naming_competitors\": true,\n    \"headline\": {\n      \"position\": \"No\",\n      \"text_only\": \"No\",\n      \"other_text\": \"No\"\n    },\n    \"background\": [\n      \"bold red\",\n      \"black\"\n    ]\n  }\n}",
"options": [],
"resource": "image"
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "ebb11f25-66f5-495e-a7bc-4212c6db10d5",
"name": "Email Creative Brief",
"type": "n8n-nodes-base.gmail",
"position": [
635,
660
],
"webhookId": "41184a90-65fd-49a8-b0de-d838b94c790c",
"parameters": {
"sendTo": "[YOUR_EMAIL]",
"message": "=Hey, \n\nWe have analyzed our competitors recent reviews.\nAnalysis data:\n{{ $today }}\n\nHere's a summary:\n{{ $('LLM Review Summary').item.json.text }}\n\nPlease see attached an AI generated 1080x1080 image which you can use in Meta ads.\n\n",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
[]
]
}
},
"subject": "=Static Creatives Based on Our competitor {{ $now }}",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
}
],
"pinData": [],
"connections": {
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "LLM Review Summary",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Check Snapshot Progress": {
"main": [
[
{
"node": "Snapshot Status Gate",
"type": "main",
"index": 0
}
]
]
},
"Combine Review Text": {
"main": [
[
{
"node": "LLM Review Summary",
"type": "main",
"index": 0
}
]
]
},
"Generate Creative Image": {
"main": [
[
{
"node": "Email Creative Brief",
"type": "main",
"index": 0
}
]
]
},
"Delay for Data Polling": {
"main": [
[
{
"node": "Check Snapshot Progress",
"type": "main",
"index": 0
}
]
]
},
"Append Reviews to Sheet": {
"main": [
[
{
"node": "Combine Review Text",
"type": "main",
"index": 0
}
]
]
},
"Form Intake for Product URL": {
"main": [
[
{
"node": "Trigger Bright Data Job",
"type": "main",
"index": 0
}
]
]
},
"Trigger Bright Data Job": {
"main": [
[
{
"node": "Delay for Data Polling",
"type": "main",
"index": 0
}
]
]
},
"LLM Review Summary": {
"main": [
[
{
"node": "Generate Creative Image",
"type": "main",
"index": 0
}
]
]
},
"Fetch Snapshot Results": {
"main": [
[
{
"node": "Append Reviews to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Snapshot Status Gate": {
"main": [
[
{
"node": "Delay for Data Polling",
"type": "main",
"index": 0
}
],
[
{
"node": "Fetch Snapshot Results",
"type": "main",
"index": 0
}
]
]
}
}
}