How to Automate Gmail to Google Sheets Data Import?
Description
Gather fresh user records, save them in files, share by email, and log them into a spreadsheet with one run. Ideal for operations teams that need quick test data, contact lists, or simple data pipelines without coding.
The flow pulls sample users from an API, maps clean fields like full name and country, and writes rows to Google Sheets. It also creates a CSV file, turns that CSV back into JSON, saves the JSON to disk, and emails it as an attachment with Gmail. The email attachment is then read back into the workflow and added to Google Sheets again. Key parts include HTTP Request, Set for field mapping, Google Sheets append, two Spreadsheet File steps for format changes, Move Binary Data for file handling, Write Binary File for storage, and Gmail to send the file.
Plan on using Google accounts for Sheets and Gmail plus OAuth in n8n. Replace the sample sheet settings with your own sheet and range. Expect faster list building and fewer copy paste errors. Good fits include seeding demo data, sharing lists with teammates, or testing file based import steps. Run it as needed from n8n and verify rows appear in your sheet and the email arrives with the JSON file.
Tools Required
What this workflow does?
- Fetch sample user data using HTTP Request from a public API.
- Map clean fields like full name and country with the Set node.
- Append rows to Google Sheets with OAuth2 and a defined range A to C.
- Convert JSON records to a CSV file using Spreadsheet File.
- Turn the CSV back into JSON for reuse and downstream steps.
- Write a JSON file to disk for storage or audits.
- Send the JSON file as an email attachment with Gmail.
- Read the email attachment back into the flow with Move Binary Data.
- Append the parsed file contents into Google Sheets again for tracking.
What are the benefits?
- Reduce manual list building from 60 minutes to 5 minutes
- Automate 90% of copy paste work between email and sheets
- Improve data accuracy by 95% by removing retyping
- Connect Gmail and Google Sheets in one simple flow
- Handle hundreds of rows per run without extra effort
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You’ll need accounts with Google Sheets and Gmail. See the Tools Required section above for links to create accounts with these services.
- In n8n, open the Google Sheets node, click Credential to connect with, select Create new credential, and follow the on screen steps to sign in with Google and approve access.
- Open the Gmail node, click Credential to connect with, select Create new credential, and complete the Google sign in and permission prompts.
- In the Google Sheets nodes, replace the sample sheet reference with your own spreadsheet. Pick the target sheet and confirm the range A:C. Keep Use path for key row enabled if your header row should be set from mapped fields.
- Open the HTTP Request node and run it once to confirm you receive user data. Check the Execution data to see result fields like name and location.
- In the Set node, confirm the field mappings for name and country. Adjust or add fields to match your sheet headers.
- In the first Spreadsheet File node, set operation to To file and file format to CSV. This creates a CSV from the mapped JSON rows.
- In the second Spreadsheet File node, set it to parse the CSV back into JSON. Keep the default delimiter unless your data requires a different one.
- In Write Binary File, keep the default file name or change it to a path that your n8n setup can write to. The default works in most cases.
- In the Gmail node, set the To address, subject, and message. Under attachments, ensure the binary property matches the Move Binary Data output property name.
- In Move Binary Data after Gmail, set source key to attachment_0 and mode to convert the attachment into JSON so it can be appended to the sheet.
- Run the workflow. Verify a new row appears in Google Sheets, the email arrives with the JSON file, and that the second Google Sheets node appends data from the email attachment.
- If a Google Sheets step fails, check the sheet ID, selected tab, and range. If the email has no attachment, confirm the binary property name matches and that the Move Binary Data nodes point to the correct keys.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
