# n8n + ProLevelMax: Weekly Review Themes From Trustpilot to Google Sheets > Build an n8n workflow: ProLevelMax pulls a company's newest Trustpilot reviews, AI sums up complaints and praise, Google Sheets logs it. About 4 cents a… Source: https://learn.ynteractive.com/content/n8n-prolevelmax-trustpilot-review-themes-google-sheets · Updated 2026-10-20 · Free from Stepthrough (https://learn.ynteractive.com) ## Practice it step by step [Start the free practice](https://learn.ynteractive.com/modules/n8n-prolevelmax-review-digest) [Take the free module: why it matters, practice and a quick check →](https://learn.ynteractive.com/courses/n8n-jump-start/21) You do every step yourself in a practice copy of n8n. It checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, about 10 minutes, and nothing touches your real accounts. [Open full screen](https://learn.ynteractive.com/modules/n8n-prolevelmax-review-digest) Free · Live now · [n8n Automation Toolkit](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) · [n8n](https://learn.ynteractive.com/content/tool/n8n) · ProLevelMax · OpenAI · Google Sheets · ~10 min · 23 steps · Intermediate Updated October 20, 2026. Built against the tool’s current screens and checked step by step. [How we check this lesson](https://learn.ynteractive.com/content/about#how-we-check) Reading reviews one by one is slow, and the star rating barely moves, so the useful part, the reasons, gets missed. In this free [n8n](https://learn.ynteractive.com/content/tool/n8n) tutorial you set up a workflow that reads them for you every Friday. ProLevelMax, a pay-per-call data [API](https://learn.ynteractive.com/content/glossary/api), returns a company's newest Trustpilot reviews through one [HTTP Request node](https://learn.ynteractive.com/content/glossary/http-request-node), a [Code node](https://learn.ynteractive.com/content/glossary/code-node) trims them, OpenAI writes the top complaints, top praise and one talking point, and Google Sheets gets one row a week. 30 reviews cost about 4 cents. The workflow and the sheet headers are free downloads with no credentials in them. This is my own lesson, not an official ProLevelMax course. ## At a glance | Question | Answer | | --- | --- | | What you build | Stop reading reviews one by one. Every Friday n8n asks ProLevelMax for a company's newest Trustpilot reviews, AI sums up the top complaints and praise, and one row lands in Google Sheets, for about 4 cents a week. | | Tools | n8n | | Time | About 10 minutes, 23 steps in 7 parts | | Level | Intermediate | | Cost | Free | | Ways to learn it | [Practice it step by step](https://learn.ynteractive.com/modules/n8n-prolevelmax-review-digest) | ### The 7 parts, in short 1. The Friday review read: See what the reading costs, Let n8n read them for him. 2. Find the source in ProLevelMax: Make an API key, Search for Trustpilot, Open the source, Read the field names, and 1 more step. 3. Get the reviews in n8n: Open the HTTP Request node, POST to /v1/run, Use a Bearer Auth credential, Paste the JSON body. 4. Let AI find the themes: Know the key error, Keep rating and text, One tidy item, Read the prompt, and 1 more step. 5. Log it in Google Sheets: Make the sheet row, Point it at your sheet, Map automatically. 6. Test it: Run it once. 7. What it saves: Read the row, See what it saves, Get the workflow. **Start here first:** [n8n: What Is n8n? Build Your First Workflow](https://learn.ynteractive.com/content/n8n-tutorial-for-beginners-first-workflow) (module 1 of n8n Automation Toolkit) **In the course:** [Part 9 · n8n Automation Toolkit](https://learn.ynteractive.com/content/course/part-9-n8n-automation-toolkit) (Module 89 of the [full course](https://learn.ynteractive.com/content/course)) **Part of:** [AI for Consulting & Agencies](https://learn.ynteractive.com/content/paths/ai-for-consulting-and-agencies) (step 28 of 30). Next up: [n8n + Felo: A Monday Research Brief With a Source for Every Answer](https://learn.ynteractive.com/content/n8n-felo-api-weekly-research-brief) **Part of:** [AI for Marketing Teams](https://learn.ynteractive.com/content/paths/ai-for-marketing) (step 4 of 35). Next up: [Post to Every Channel Daily from One Sheet using n8n + Blotato](https://learn.ynteractive.com/content/post-everywhere-from-google-sheets-n8n-blotato) **Part of:** [AI for Sales Teams](https://learn.ynteractive.com/content/paths/ai-for-sales) (step 20 of 20) **Part of:** [Business Automations with n8n](https://learn.ynteractive.com/content/paths/business-automations-n8n) (step 20 of 20) **Part of:** [Reports That Build Themselves](https://learn.ynteractive.com/content/paths/reports-that-build-themselves) (step 5 of 7). Next up: [n8n: Weekly Client Status Emails from a Google Sheet, Written by AI](https://learn.ynteractive.com/content/weekly-client-status-email-google-sheets-ai-n8n) **Part of:** [n8n Jump Start](https://learn.ynteractive.com/content/paths/n8n-jump-start) (step 20 of 20) **Part of:** [AI Apps Worth Knowing](https://learn.ynteractive.com/content/paths/partner-tools-ai-apps) (step 62 of 62) **Part of:** [n8n Intermediate: Real Business Workflows](https://learn.ynteractive.com/content/paths/n8n-intermediate) (step 5 of 13). Next up: [Webhooks and Forms in n8n: Capture Data from Anywhere](https://learn.ynteractive.com/content/n8n-webhook-and-form-trigger-tutorial) ## The n8n workflow The six-node workflow from this lesson, with setup notes on the canvas. It has no credentials: create a Bearer Auth credential with your ProLevelMax key, connect OpenAI and Google, and paste your sheet's URL after you paste it onto your canvas. [Download the n8n workflow (JSON)](https://learn.ynteractive.com/templates/n8n-prolevelmax-review-digest.json) ## The sheet headers Row 1 of the Google Sheet: Week, Company, Reviews read, Average rating, Top complaints, Top praise, Talking point. Import it into a new sheet, or type the headers yourself. [Download the sheet headers (CSV)](https://learn.ynteractive.com/templates/n8n-prolevelmax-review-digest-sheet.csv) ## The business case: the Friday review read The example is Marcus Reed, who runs Fieldstone CRM Consulting, a made-up firm that helps small businesses choose and set up a CRM. Clients keep asking whether to move to Pipedrive, so every Friday he reads its newest Trustpilot reviews, about an hour of his time, or about $390 a month at $90 an hour. These are example numbers, so use your own. The average star rating barely changes from week to week. The reasons behind it do, and those are what a client wants to hear before signing. The workflow turns 30 reviews into one row he can read in a minute, and the sheet becomes a running record. ## What you need - An n8n account (n8n Cloud's trial is enough). New n8n Cloud accounts get free OpenAI credits, which the OpenAI node can use. - A ProLevelMax account and an [API key](https://learn.ynteractive.com/content/glossary/api-key). New users get $1 of free credit after verifying their email, enough for this workflow for months. - A Google account and a Google Sheet with the headers above. ## Step 1: find the source in the ProLevelMax console In the console, open API keys and click + New key, then open Data sources and search for trustpilot. Company reviews (id procli_trustpilot_a) returns customer reviews and ratings of a company, at $0.0012 per result on 20 October 2026. Click Collect to see its fields: companyUrls (a list, such as ["pipedrive.com"]), maxReviewsPerCompany, stars, languages, sort (recency for the newest), date, publishedAfter, verified, withReplies and includeCompanyInfo. Close the form without clicking Run: Run charges your balance, and n8n will make the call. The same Data sources list has other review sites, such as G2, Capterra, Google Maps and Yelp. Each has its own id and fields, which you read the same way in Collect. ## Step 2: call ProLevelMax from n8n Download the workflow below, open the file, copy everything and paste it onto an n8n canvas. Every Friday at 8am is a Schedule Trigger. Get new reviews (ProLevelMax) is an [HTTP Request node](https://learn.ynteractive.com/content/glossary/http-request-node): Method POST, URL https://prolevelmax.com/v1/run, Authentication Generic Credential Type, Generic Auth Type Bearer Auth, with your key in the credential's Bearer Token. Send Body is on, as JSON: {"scraper": "procli_trustpilot_a", "input": {"companyUrls": ["pipedrive.com"], "maxReviewsPerCompany": 30, "sort": "recency", "languages": ["en"]}, "maxItems": 30} The Timeout option is 2 minutes, because collecting reviews takes a little while. A missing or wrong key returns Authorization failed with invalid key format, which is what the lesson's test run shows with a placeholder key. ## Step 3: trim the reviews and let AI find the themes Keep rating and text is a Code node that reads the reviews from items and keeps each one's rating, title, text (trimmed to 700 characters) and date, plus the count and the average rating. It checks a few common field names, so check one real run's output and adjust the names if ProLevelMax's differ. Find the themes is OpenAI's Message a Model node. The prompt says to use only what the reviews say, invent no numbers, and reply with [JSON](https://learn.ynteractive.com/content/glossary/json) only, with top_complaints, top_praise and talking_point. In the lesson's run on eight sample reviews it returned price increases and gated features, limited reporting and slow support as complaints, and easy setup, the drag-and-drop pipeline and the mobile app as praise. ## Step 4: one row in Google Sheets Make the sheet row is a Code node that reads the AI's JSON (stripping a code fence if the model adds one) and names each field like a column: Week, Company, Reviews read, Average rating, Top complaints, Top praise, Talking point. Add this week's row is Google Sheets, Append Row, with your sheet's URL and Mapping Column Mode set to Map Automatically, so each field lands in the column with the same name. Click Execute once to log this week's row now. Check it, then Publish the workflow so it runs every Friday. ## Mistakes to avoid - Clicking Run in the Collect form to test. It charges your balance; let n8n make the call. - Putting the key in the JSON body or the URL. Keep it in the Bearer Auth credential. - Sending every field to the AI. Trim the reviews first. - Quoting the summary to a client without reading a few of the reviews behind it. ## Cost From the ProLevelMax console on 20 October 2026: Company reviews (Trustpilot) is $0.0012 per result, so 30 reviews a week is about 4 cents, or about 16 cents a month, paid from a prepaid balance with no subscription. New users get $1 of free credit after verifying their email. Sign up through [my referral link](https://prolevelmax.com/?ref=nfi72xac) (partner link, I may earn a commission, at no cost to you) and you get 20% extra on your first top-up. Check prolevelmax.com/pricing for current prices. ## Links - [Try ProLevelMax](https://prolevelmax.com/?ref=nfi72xac) (affiliate link): the data API this lesson uses. New users get $1 of free credit after verifying their email, and 20% extra on their first top-up through this link. - [ProLevelMax docs](https://prolevelmax.com/docs): the REST API: discover, inspect, run and runs. - [ProLevelMax pricing](https://prolevelmax.com/pricing): current prices per call and per result for each source. - [ProLevelMax in the AI tools directory](https://learn.ynteractive.com/content/ai-tools/research-search#tool-prolevelmax): what it does, what it costs, and every Stepthrough lesson that uses it. - [n8n Google Sheets node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/): Append Row and Map Automatically. Disclosure: links marked "affiliate link" are partner links. If you sign up through one, Stepthrough may earn a commission at no extra cost to you. The lesson is free either way and does not depend on it. ## Try it yourself, free Reading the steps is a start. Doing them is how it sticks. The interactive module walks you through every click in a practice copy of n8n, checks each step, and never touches your real accounts. [Start “n8n + ProLevelMax: Weekly Review Themes From Trustpilot to Google Sheets”](https://learn.ynteractive.com/modules/n8n-prolevelmax-review-digest) ## Step by step: n8n + ProLevelMax: Weekly Review Themes From Trustpilot to Google Sheets All 23 steps of the interactive module, in order. In the module you watch each one, then do it yourself in a practice copy that checks your work. ### 1. The Friday review read 1. **See what the reading costs.** **Marcus Reed** runs **Fieldstone CRM Consulting** (made up). Clients keep asking whether to move to **Pipedrive**, so every Friday he reads its newest Trustpilot reviews to know what's going wrong and right this week. Click the last row. Meet Marcus. He's a C R M consultant. Every Friday, he reads the newest reviews of a C R M his clients ask about. 2. **Let n8n read them for him.** The fix: an n8n workflow asks **ProLevelMax** for the newest reviews, AI groups them into complaints, praise and one talking point, and the row lands in Google Sheets. Marcus reads one row instead of 30 reviews. Click the workflow. Here's the fix. ProLevelMax pulls the reviews. A I finds the themes. And a row lands in Google Sheets. ### 2. Find the source in ProLevelMax 3. **Make an API key.** Sign up at **prolevelmax.com**: new users get **$1 of free credit**. In the console, open **API keys** and click **+ New key**. Copy it for n8n. Click **+ New key**. Sign up at prolevelmax dot com. New users get a dollar of free credit. 4. **Search for Trustpilot.** Open **Data sources**. There are over 1,000 sources on 157 platforms, including review sites like Trustpilot, G2, Capterra and Google Maps. Type **trustpilot** in **Search sources**. Click the **search box**. There are over a thousand. Search for trustpilot. 5. **Open the source.** **Company reviews**: customer reviews and ratings of a company, **$0.0012 per result**. Its id, **procli_trustpilot_a**, is what n8n sends. Click **Collect** to see its fields. Company reviews. About a tenth of a cent per review. Note its I D. 6. **Read the field names.** The field names go straight into n8n: **companyUrls** (a list, such as `["pipedrive.com"]`), **maxReviewsPerCompany**, **languages** and **sort** (**recency** for the newest). **Run** would charge your balance, and you don't need it: n8n makes the call. Click the **fields**. These field names go straight into n8n. Company U R Ls, max reviews, languages, and sort by recency. 7. **Close the form.** Click **Close**. Now over to n8n. Now, over to n8n. ### 3. Get the reviews in n8n 8. **Open the HTTP Request node.** Here's the workflow, with a setup note on the left. Download it from the guide page and paste it onto your canvas. A **Schedule Trigger** runs it **every Friday at 8:00**. Double-click **Get new reviews (ProLevelMax)**. Here's the workflow. It runs every Friday at eight. Double click Get new reviews. 9. **POST to /v1/run.** **Method** is **POST** and **URL** is **https://prolevelmax.com/v1/run**, the same address for every source. Click **URL**. Method POST, to prolevelmax dot com slash v1 slash run. It's the same for every source. 10. **Use a Bearer Auth credential.** **Authentication** is **Generic Credential Type**, **Generic Auth Type** is **Bearer Auth**. Create a credential and paste your key into **Bearer Token**. Here it's named **ProLevelMax - add your key**. Click **Bearer Auth**. Use a Bearer Auth credential, with your ProLevelMax key in it. 11. **Paste the JSON body.** **Send Body** is on, as **JSON**: the source id in **scraper**, the fields from the Collect form in **input**, and **maxItems: 30**. 30 reviews is about **4 cents** a week. The **Timeout** is 2 minutes, because collecting reviews takes a little while. Click the **JSON** box. The body names the source, then the same fields you saw in Collect. Thirty reviews is about four cents. ### 4. Let AI find the themes 12. **Know the key error.** This is a real run with a placeholder in the credential, so ProLevelMax answers **Authorization failed**: **invalid key format**. With your key it returns the reviews in **items**. Click the **error**. This test used a placeholder key, so ProLevelMax says invalid key format. With your key, you get the reviews. 13. **Keep rating and text.** **Keep rating and text** trims each review to its **rating**, **title**, **text** and **date**, and works out the average. The reviews in this run are **SAMPLE** reviews, pinned for testing. Click the **code**. A Code node keeps the rating, title, text and date. And works out the average. These are sample reviews. 14. **One tidy item.** One item: **company**, **count**, **average** and the trimmed **reviews**. Click the **output**. One tidy item. 15. **Read the prompt.** The **OpenAI** node uses n8n's free OpenAI credits. The prompt says: use only what the reviews say, invent no numbers, and reply with **JSON only**: **top_complaints**, **top_praise** and **talking_point**. Click the **Prompt**. The OpenAI node reads the reviews. Use only what they say. Reply with three things, as JSON. 16. **See the themes.** A real run on the sample reviews: price increases and gated features, limited reporting, slow support; praised for easy setup, the pipeline and the mobile app. Click the **output**. A real run. Complaints, praise, and one talking point. ### 5. Log it in Google Sheets 17. **Make the sheet row.** **Make the sheet row** reads the AI's JSON and names each field like a column: **Week**, **Company**, **Reviews read**, **Average rating**, **Top complaints**, **Top praise**, **Talking point**. Click the **output**. A Code node turns the answer into one row, with a column for each field. 18. **Point it at your sheet.** **Google Sheets**, **Append Row**. Connect your Google account and paste your sheet's URL in **Document**. Make the headers first: there's a CSV with them on the guide page. Click **Document**. Google Sheets, Append Row. The guide page has the headers. 19. **Map automatically.** **Mapping Column Mode** is **Map Automatically**: each field lands in the column with the same name. Click **Mapping Column Mode**. Map automatically. Each field lands in the column with the same name. ### 6. Test it 20. **Run it once.** With your key in place, click **Execute** to log this week's row now. Here every node after ProLevelMax ran on the sample reviews. Check the row, then **Publish** so it runs every Friday. Click **Execute**. Check it. Then publish. ### 7. What it saves 21. **Read the row.** This is the row from the test run, on sample reviews. Each Friday adds one, so the sheet becomes a running record of what customers say. Click the row. Here's the row from the test run. Every Friday adds one more. 22. **See what it saves.** About an hour of reading a week, for about 4 cents. Click **What this saves**. About an hour a week, for about four cents. 23. **Get the workflow.** Download the workflow and the sheet headers from the guide page. Click the card. Download the workflow and the sheet headers. ## Frequently asked questions **Is this an official ProLevelMax course?** No. This is my own lesson. ProLevelMax is a separate, third-party product from prolevelmax.com. **What does it cost?** $0.0012 per review for the Trustpilot Company reviews source on 20 October 2026, so 30 reviews a week is about 4 cents. New users get $1 of free credit. The OpenAI step can use n8n Cloud's free OpenAI credits to start. **Can I read G2, Capterra or Google Maps reviews instead?** Yes. Each is its own source in the ProLevelMax Data sources list. Swap the scraper id in the JSON body and use that source's field names from its Collect form. **Why does the test run show Authorization failed?** The lesson's run used a placeholder key on purpose, so no real key was made and nothing was charged. The error proves n8n reached ProLevelMax with the right URL and header. Paste your real key into the credential and the node returns reviews. **Can it watch several companies?** Yes. companyUrls is a list, so add your competitors. Then change the Code node to group the reviews by company before the AI step, or run one workflow per company. [Start this module free](https://learn.ynteractive.com/modules/n8n-prolevelmax-review-digest) - Previous in n8n Automation Toolkit: [n8n + Felo: A Monday Research Brief With a Source for Every Answer](https://learn.ynteractive.com/content/n8n-felo-api-weekly-research-brief) - Next in n8n Automation Toolkit: [n8n: Turn Meeting Notes into Action Items in a Google Sheet](https://learn.ynteractive.com/content/meeting-notes-to-action-items-google-sheets-ai-n8n) ## More in n8n Automation Toolkit - [n8n: What Is n8n? Build Your First Workflow](https://learn.ynteractive.com/content/n8n-tutorial-for-beginners-first-workflow): What n8n is and how it thinks, then your first workflow: a client inquiry form that catches every request and writes a one-line summary. No code, no accounts to connect. - [AI Workflow Automation for Beginners: Sort Every Client Inquiry and Draft the Reply using n8n](https://learn.ynteractive.com/content/ai-workflow-automation-for-beginners): AI workflow automation for beginners: a form catches each client inquiry, an AI step sorts it and drafts the reply, and an If rule flags the urgent ones. Real n8n, free… - [n8n: Items, JSON and Expressions, Explained by Doing](https://learn.ynteractive.com/content/n8n-items-json-expressions-tutorial): See how n8n holds data: pin five fake invoices, read them as items, Table and JSON, then write one reminder per invoice and a late fee with drag-and-drop expressions. - [n8n: Run a Workflow on a Schedule (Every Monday at 8am)](https://learn.ynteractive.com/content/n8n-schedule-trigger-tutorial): Use the n8n Schedule Trigger to run a workflow by itself: every Monday at 8am, a timesheet reminder. Set the interval, test it now, and check the time zone. - [n8n: Send Form Answers Straight to Google Sheets](https://learn.ynteractive.com/content/n8n-form-to-google-sheets): Build a consultation request form in n8n (required fields, email, dropdown), test it, and add every answer as a new row in Google Sheets. No webhook, no form tool to… - [n8n: Summarize Customer Emails with OpenAI](https://learn.ynteractive.com/content/n8n-openai-summarize-emails): Your first AI step in n8n: send each customer email to OpenAI with one prompt and get a one-line summary plus the next step. No agent needed, about a cent of API use. [All 24 modules in n8n Automation Toolkit](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) ## More n8n tutorials - [n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets): Build an AI agent for BrightPath Marketing that generates social media post ideas and saves them to Google Sheets — chat trigger, AI Agent, system prompt, model… - [Lovable + n8n: Build a Web App with an AI Backend](https://learn.ynteractive.com/content/lovable-n8n-web-app-ai-backend): Build a contact form in Lovable and connect it to an n8n workflow — webhook trigger, AI Agent, Google Sheets, Gmail, and a Respond node that ties it all together. - [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets): Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. - [n8n AI Email Responder: Draft Gmail Replies Automatically](https://learn.ynteractive.com/content/ai-email-responder-gmail-drafts-n8n): Build an n8n agent that watches your Gmail, reads each new customer email, and writes a reply as a draft in the same thread, ready for you to check and send. - [Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail): Every morning at 7, n8n reads a plumbing company's jobs sheet, skips anything not assigned yet, and emails each job to the tech it's assigned to — customer, address… - [Gmail AI Triage: Auto-Label Every Email and Draft Replies](https://learn.ynteractive.com/content/gmail-ai-triage-labels-drafts-n8n): Build an n8n workflow that reads each new email, sorts it as a lead, a client or an invoice with a Text Classifier, adds the matching Gmail label, and drafts a reply to… ## Terms in this lesson Plain-English definitions, each with an example from a free lesson. [API](https://learn.ynteractive.com/content/glossary/api) · [HTTP Request node](https://learn.ynteractive.com/content/glossary/http-request-node) · [Code node](https://learn.ynteractive.com/content/glossary/code-node) · [CRM](https://learn.ynteractive.com/content/glossary/crm) · [n8n Cloud](https://learn.ynteractive.com/content/glossary/n8n-cloud) · [AI credits](https://learn.ynteractive.com/content/glossary/ai-credits) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Browse related tutorials [n8n Automation Toolkit (24)](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) · [n8n tutorials (53)](https://learn.ynteractive.com/content/tool/n8n)