Quick overview
Quick overview Sign up for Decodo HERE For Discount This template scrapes public reviews from Trustpilot and Sitejabber with a Decodo tool, converts findings into a flat, spreadsheet-ready JSON, generates a concise sentiment summary with Gemini, and appends everything to Google Sheets. How it works A Form Trigger collects the target business name or URL submitted by the user as the starting point. The Set node stores business_name, spreadsheet_id, and sheet_id as reusable configuration variables for downstream nodes. An AI Agent orchestrates the Decodo scraping tool and enforces a strict JSON schema, collecting at most 10 reviews per source. Gemini generates a concise sentiment summary and recommendations, noting any missing sources with: "There's no data in this website." A Merge node combines the structured JSON review fields with the Gemini narrative into a single flat output. Google Sheets appends a new row containing all merged data from the previous step. Setup Add your Google Sheets, Gemini, and Decodo credentials in the n8n Credential Manager before activating the workflow. Open the Set: Config Variables node and replace (YOUR_SPREADSHEET_ID) and (YOUR_SHEET_ID) with your actual Google Sheets identifiers. In the Google Sheets node, select Define below as the mapping mode and explicitly map each column to its corresponding field. Keep the parser and agent node connections intact and unmodified to guarantee the output remains a flat, appendable JSON structure. Activate the workflow, open the form URL, submit a business name, and verify that a new row is correctly appended to your sheet. Additional info Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com → Learn to build it yourself: academy.withmiautomation.com → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com. An n8n automation workflow template by Fahmi Fahreza.
Fahmi Fahreza
web
free
Others in the same category, ranked by how often they are opened.
