Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Automate Google Sheets Currency Updates
13
Views
0
Downloads
10
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Finance
Automation Orchestrator
n8n
Integrations
Google Sheets
ExchangeRate API
Trigger Type
Schedule
Approx setup time ≈ 35 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Automate Google Sheets Currency Updates?

Leon Petrou
FREE TEMPLATE
Automate Google Sheets Currency Updates
13
Views
0
Downloads
10
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Finance
Automation Orchestrator
n8n
Integrations
Google Sheets
ExchangeRate API
Trigger Type
Schedule
Approximate setup time ≈ 35 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

Keep your finance sheet current without manual work. A daily run collects the latest USD exchange rates, updates an invoice sheet, and records a full history for audits and reporting. Ideal for teams that bill in USD and need reliable daily rates for quotes and invoices.

At 8 am, a schedule starts an API call to fetch USD rates. A small code step reshapes the response into a flat JSON list of currencies. A field filter pulls base currency and the update time. A merge step combines these details, then one Google Sheets step updates your invoice template while another appends the full set of rates to an archive sheet. You get a fresh figure for the day and a clean log of prior days in the same file.

Setup needs an ExchangeRate API key and Google Sheets access in n8n Cloud. Expect less manual copying, fewer mistakes, and faster quotes. Helpful for daily invoicing, budget checks, and monthly close where you need a clear audit trail of historical rates.

Copy link

Tools Required

n8n
Sign up
$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.
Google Sheets
Sign up
Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)
ExchangeRate API
Sign up
Free tier: $0 / mo, 1,500 API requests / mo; updates once per day

Video Tutorial

What this workflow does?

  • Daily schedule at 8 am to run the rate refresh automatically
  • HTTP request to fetch the latest USD exchange rates from the API
  • Code step flattens conversion rates into a simple JSON map
  • Field filter extracts base currency and the last update time
  • Merge step combines metadata with the full currency list
  • Google Sheets update writes the current rate and timestamp to the invoice sheet
  • Google Sheets append adds a new row of all rates to the Archives sheet

What are the benefits?

  • Reduce manual work from 30 minutes to 2 minutes per day
  • Improve data accuracy by 90 percent by removing copy paste
  • Keep a daily audit trail of rates in one archive sheet
  • Handle over 100 currencies with one API call
  • Connect API data to Google Sheets every morning without reminders

How to set this up?

  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 and ExchangeRate API. See the Tools Required section above for links to create accounts with these services.
  3. Open the HTTP Request node. Replace the placeholder in the URL with your ExchangeRate API key. If you prefer credentials, double click the node, create a new credential, and follow the on screen steps.
  4. Test the HTTP Request node by clicking Execute Node. You should see a JSON object that includes conversion_rates and base_code.
  5. Open the Code node and keep the default script that outputs the conversion_rates map. Run the node to confirm a flat list of currency keys and values.
  6. Open the Set node named Filter Fields and verify it maps base currency and update time fields. Make sure the field names match the headers you plan to use in Google Sheets.
  7. Open the Google Sheets node named Update Rate Sheet. In the credentials dropdown, click Create new credential, sign in with your Google account, and allow access. Select your spreadsheet by URL or ID and choose the invoice sheet. Use the Update operation and set a match column that identifies the row to update such as base_currency.
  8. Open the Google Sheets node named Archive Rates. Use the same credential. Select the same spreadsheet and pick the Archives sheet. Keep the Append operation and confirm the sheet has headers for base_currency, time, and currencies you want to store.
  9. Run the full workflow once. Check the invoice sheet for the current rate and timestamp. Check the Archives sheet for the new row of daily rates.
  10. Open the Schedule Trigger node and confirm the time and timezone match your team. Adjust the hour if you want a different local run time.
  11. If you see a 403 or permission error in Google Sheets, make sure the Google account used in n8n has edit access to the file. Share the sheet with that account if needed.
  12. If the API call fails, verify the API key value and quota on the ExchangeRate API dashboard. Fix the key and test again.
  13. Activate the workflow so it runs every morning. Monitor executions in n8n and review logs if any step fails.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

n8n
Finance
Automate LINE Payments to Google Sheets
Capture bank slip images sent on LINE, save the file in Google Drive, and log key payment details in Google Sheets. Teams can confirm transfers fast without typing data by hand. Ideal for stores that verify payments before shipping orders. A webhook receives an image from LINE. The flow builds the file URL, downloads the image with secure headers, and uploads it to a set Drive folder with the message id as the file name. An OCR.space request reads Thai text from the slip and returns raw text. Code then pulls fields like amount, fee, date and time, sender name, and receiver bank. The row is appended to a sheet with clean columns for easy review. Setup needs a LINE Messaging API channel, a Google account for Drive and Sheets, and an OCR.space API key. Expect faster checks and fewer mistakes, often cutting slip handling from 15 minutes to 2 minutes per payment. Great for shops that get transfer slips on chat and need a daily payment log with both the image and the parsed data in one place.
1 views
view
n8n
Finance
Automate Gmail Invoice Filing to Google Drive
Turn invoice emails into dated PDFs and file them in the right Google Drive folder without touching a mouse. Built for teams that get billing emails with a link to view the invoice online, this setup keeps finance records tidy and easy to find. A Gmail trigger checks your inbox every minute. A rule keeps only messages that match your sender or subject. The HTML step pulls all links in the email and a split step looks at each link. A filter keeps the invoice link only. A web call sends that link to a PDF service to create a clean PDF. The file is then uploaded to Google Drive, renamed with today’s date, and moved into your chosen folder. Messages that do not match are ignored. You will need Gmail and Google Drive connected in n8n Cloud and an API key for a PDF conversion service. Paste your API key and your Drive folder URL in the setup node. Adjust the match rules to your vendor’s sender or subject. Expect to cut monthly filing from an hour to a few minutes and reduce naming mistakes. This is great for subscription receipts, SaaS invoices, and vendor bills sent as links.
2 views
view
n8n
Finance
Automate LINE to Google Sheets Slip Capture
Collect payment slip data directly from chat and store it in a sheet without manual typing. Users send a message or a slip image in LINE, get an instant reply, and the key fields go into Google Sheets for finance tracking and review. A webhook receives each LINE message and a Switch classifies it as text or image. For text, a chat agent with memory answers the user using Gemini, so the bot remembers the same user across messages. For images, the flow downloads the image from LINE, sends it to Gemini with a clear prompt, and expects JSON with Status, From, To, Date, and Amount. The bot replies to the user in LINE and then writes the slip results to Google Sheets in the same structure. This creates one place to handle both free text and payment slip images. You will need a LINE Messaging API channel, a Google Sheets spreadsheet with the needed columns, and a Google Gemini API key. Teams can cut data entry time and reduce errors from manual reading. Common uses include bank slip verification, expense reviews, and payment confirmations inside chat. Set the sheet columns, connect your credentials, and test with a real slip image to see the record appear in seconds.
12 views
view
See More Templates

Credits: YouTube video - 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. If you are the author and would like this template removed from the template library, email us at info@futurise.com and we will remove it promptly.