{"product_id":"n8n-workflow-track-web-table-changes-in-google-sheets","title":"n8n Workflow: Track Web Table Changes in Google Sheets","description":"\u003ch3\u003eAutomatically detect web table changes and log them in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning to scrape an HTML table from a web page with \u003cstrong\u003eGaffa\u003c\/strong\u003e, sync it to your Google Sheets “Table” tab, and writes an audit trail of \u003cstrong\u003eadditions, changes, and removals\u003c\/strong\u003e into a “Changes” tab—complete with timestamps and field-level before\/after details for updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Executes every morning on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrape with Gaffa:\u003c\/strong\u003e Loads the configured page and extracts the target HTML table into structured rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFail fast on bad input:\u003c\/strong\u003e Stops with an error if the table can’t be read or if no rows contain the configured \u003cstrong\u003ekey column\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize and filter:\u003c\/strong\u003e Keeps only rows where the key column has a value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompare current vs. stored data:\u003c\/strong\u003e Reads existing rows from Google Sheets “Table” (excluding rows already marked as removed) and detects:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eNew entries\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eChanged entries\u003c\/strong\u003e (using the key column)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eRemoved entries\u003c\/strong\u003e (rows missing from the latest scrape)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate Google Sheets:\u003c\/strong\u003e Appends new rows with \u003cem\u003efirst_seen\u003c\/em\u003e and \u003cem\u003elast_changed\u003c\/em\u003e, updates changed rows in place (refreshing \u003cem\u003elast_changed\u003c\/em\u003e), and marks removals by setting \u003cem\u003eremoved_on\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite an audit log:\u003c\/strong\u003e Adds a change-log entry to the “Changes” tab for each addition, change (including field-level before\/after), and removal.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack updates to publicly available tables (releases, pricing lists, rosters, status pages) and maintain an up-to-date dataset in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eMonitor competitor or partner webpages and capture a daily history of what changed.\u003c\/li\u003e\n  \u003cli\u003eProvide SaaS ops teams a lightweight change tracking trail for spreadsheet-based reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGaffa node:\u003c\/strong\u003e Uses the community node \u003cem\u003e@gaffa-dev\/n8n-nodes-gaffa\u003c\/em\u003e with a Gaffa API credential to extract the HTML table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Creates\/uses tabs matching your settings (default “Table” and “Changes”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic nodes:\u003c\/strong\u003e Includes \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e, and workflow notes (\u003cem\u003esticky note\u003c\/em\u003e) to control scraping, validation, and synchronization behavior.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232407605427,"sku":"N8N-21055","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2Q3KjeWVdzy-c_5Fai8cR_ElElJJuB.png?v=1792141873","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-web-table-changes-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}