Scheduled Web Scraper to Google Sheets

Checking a competitor's pricing page or a listings site by hand every day is exactly the kind of work computers should do. Scraping SaaS starts at $30/month. This workflow fetches any public page on a schedule, extracts the pieces you care about with CSS selectors, and appends a dated row to Google Sheets.

What this workflow does

1. A Schedule Trigger fires every morning at 8:00.
2. An HTTP Request node fetches the target page's HTML.
3. An HTML node extracts values using CSS selectors (price, title, stock status - whatever you point it at).
4. A Code node stamps each row with today's date.
5. A Google Sheets node appends the row, building a time series you can chart.

Setup guide

1. Import the JSON into n8n (Workflows > Import from File).
2. Put your target URL in the HTTP Request node.
3. Open the target page in your browser, right-click the value you want > Inspect, and copy a CSS selector for it into the HTML node.
4. Connect Google Sheets and pick your spreadsheet; column names come from the Code node output.
5. Run once manually to verify the extraction, then activate.
6. Only scrape public pages, respect robots.txt, and keep the schedule gentle (once a day, not once a second).

FAQ