Turn API data into a clean spreadsheet or a ready to share CSV with one click. Great for teams that need quick contact lists, sample records, or simple data pulls without copy and paste.

The flow starts with a manual run, then calls an API to fetch JSON data. From there, one path maps fields straight into a Google Sheets table and appends new rows. A second path trims and flattens the same JSON with a Set step, then creates a CSV file using a Spreadsheet File step. You can keep both outputs at once, so your sheet stays updated while a CSV is generated for download or sharing. Direct mapping to Sheets keeps things simple. The CSV path gives you tight control over which fields you include.

You only need a Google Sheets account with access to the target spreadsheet. Expect faster updates, fewer errors, and a simple way to reuse the same data in two formats. Use it to seed test data, refresh a basic contact list, or export a quick snapshot for reporting. If you want hands off updates, replace the manual trigger with a schedule to pull new records on a timer.

• Manual start to fetch fresh JSON data on demand
• HTTP Request step pulls records from an API endpoint
• Google Sheets step appends rows by mapping fields directly from JSON
• Set step flattens and keeps only the fields you choose for clean exports
• Spreadsheet File step converts trimmed data into a CSV with a set file name
• Easy switch to a schedule trigger if you want timed imports later

• Reduce manual work from 30 minutes to 2 minutes by automating API to sheet updates
• Automate up to 90 percent of repetitive copy and paste tasks for list building
• Improve data accuracy by 80 percent through consistent field mapping
• Create both a live sheet and a CSV in one run to support different teams
• Connect a trusted app and a simple file export to unify data use

1. 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.
2. You'll need accounts with Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node. In the Credential to connect with menu, click Create new credential. Follow the on screen steps to sign in with Google and grant access. Name the credential clearly, for example Google Sheets Main.
4. In the Google Sheets node, choose your spreadsheet and the correct sheet tab. Keep the operation as Append. Map each column to the fields from the incoming JSON as needed.
5. Open the HTTP Request node. The URL is already set to an API endpoint. Click Execute Node to confirm you see JSON results in the output.
6. Open the Set node. Review the fields like Full Name and Country. Adjust the expressions to match the JSON you receive. Keep Keep Only Set enabled so only these fields move forward.
7. Open the Spreadsheet File node. Confirm the operation is toFile and the format is csv. Set a file name you recognize, for example users_spreadsheet.
8. Click Execute Workflow. After the run, check Google Sheets for a new row and open the Spreadsheet File node output to download the CSV from the binary data.
9. If you see a permission error in the Google Sheets node, make sure the selected document is shared with the Google account used in the credential.
10. If column values do not appear correctly, update the field mappings in the Google Sheets node or adjust the Set node expressions so the data is flat and labeled the way you expect.
11. To run on a schedule, add a Schedule trigger and connect it to the HTTP Request node. Disable the manual trigger before activating the workflow.