Move weekly public health testing data into Google Sheets for fast reporting. Ideal for analysts who track Germany Austria and Switzerland during 2023. Run it when needed to refresh a clean table.

After you click run, the flow downloads a live CSV from a public data source. It reads the file, creates a unique key from country code and week, and keeps only DACH rows for 2023. It then writes data to a chosen sheet using append or update, so new weeks are added and existing weeks are updated without duplicates. The Google Sheets node uses user entered cell format to keep values readable in the sheet. The result is a reliable view for weekly monitoring and simple sharing.

Setup needs a Google Sheets account and OAuth access in n8n. Expect a big cut in manual work and fewer copy paste errors. If you plan to load the full dataset or very large files, add Split In Batches and a Wait between batches to respect Google API limits. Great for weekly KPI decks, regional reports, and quick checks across Germany Austria and Switzerland.

• On demand run with a manual trigger for controlled refreshes
• HTTP download of the latest CSV from a public data source
• CSV parsing with header support for clean field mapping
• Unique key built from country code and week to prevent duplicates
• Filter keeps only Germany Austria and Switzerland and only weeks from 2023
• Google Sheets append or update writes new rows and updates existing rows
• User entered cell format keeps numbers and dates readable in the sheet

• Reduce manual work from 60 minutes to 2 minutes per update
• Automate up to 90 percent of repetitive download and copy tasks
• Improve data quality by 95 percent with unique key updates and no duplicates
• Connect open data to Google Sheets for instant sharing with teams
• Scale to larger files by adding batching and short waits to avoid rate limits

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. In the n8n credentials manager, create a new Google Sheets OAuth2 credential. Name it clearly, then follow the on screen steps to sign in and grant access.
4. Open the Upload to spreadsheet node. Select your Google Sheets credential, paste the spreadsheet URL, pick the target sheet tab, set operation to append or update, and set unique_key as the match field.
5. Open the HTTP Request node and confirm the CSV URL is correct. Leave authentication empty since the file is public.
6. Open the Import CSV node and make sure Header row is enabled so fields map correctly.
7. Open the Add unique field node and confirm the expression unique_key equals country_code hyphen year_week. This powers deduping in the sheet.
8. Open the Keep only DACH in 2023 filter and confirm the year starts with 2023 and the country list includes DE AT CH.
9. Click Execute Workflow. Check the sheet to confirm only DE AT CH rows from 2023 are present and that rerunning updates existing weeks instead of creating duplicates.
10. If you see Google API rate limit errors, insert a Split In Batches node before the Google Sheets node and a Wait node after it. Use a short delay like 1 to 5 seconds per batch.
11. Optional scheduling: add a Cron node to run weekly on your reporting day and connect it to the HTTP Request node.
12. Troubleshooting: if numbers look wrong, ensure the Google Sheets node option cell format is set to user entered. If updates do not occur, verify the sheet has a column named unique_key and that it matches the node mapping.