Extract web page data from Gmail links and save to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Search Emails (Gmail): get many
- search for an element in the email body (HTML): parses or builds HTML
- open the link (HTTP Request): calls an HTTP API
- capture data (HTML): parses or builds HTML
- processes information (Code): runs custom JavaScript code
- set variables (Edit Fields (Set)): sets 9 fields: id, Nome_Paciente, Dt_solicitacao…
- Save data in spreadsheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Gmail
n8n-nodes-base.gmail - HTML
n8n-nodes-base.html - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
How it works This workflow automatically extracts specific data from received emails and saves it into a Google Sheets document for easy tracking and analysis. It connects to a Gmail account, searches for emails received within a defined date range from a…