Integrate Zoho Sheet with Exchangerates API

Send information between Zoho Sheet and Exchangerates API automatically, without writing any code, using Zoho Flow.

Explore prebuilt integration flows to get started

[esc]

Log the exchange rate in Zoho Sheet once a month using Exchange Rates API


It can be painful to maintain multiple exchange rates and then locate the one you need?  Automatically recording and maintaining monthly currency exchange rates in one place will make it easier to access data. This flow will log exchange rates in Zoho Sheet once a month using Exchange Rates API.

How it works
1) A monthly exchange rate is generated in Exchange Rate API.
2) Zoho Flow records it in Zoho Sheet.
Use this flow
+
+

Log the exchange rate in Zoho Sheet once a month using Exchange Rates API

Schedule Trigger + Exchangerates API + Zoho Sheet

Didn't find the integration you were looking for?

Integrate your apps to automate those tedious tasks. Save hours every day.

Supported triggers and actions

All Triggers - A trigger kickstarts the flow

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Row created - WorkDrive

Triggers when a new row is created in a spreadsheet stored in Zoho WorkDrive

Row created

Triggers when a new row is added at the bottom of the selected worksheet

Row created or updated

Triggers when a row is added or updated in the selected worksheet

Row created or updated - WorkDrive

Triggers when a row is created or updated in a spreadsheet stored in Zoho WorkDrive

Worksheet created - WorkDrive

Triggers when a new worksheet is created in WorkDrive

Spreadsheet created

Triggers when a new spreadsheet is created

All Actions - Actions are the automated tasks

Create worksheet

Creates a new worksheet in the selected spreadsheet

Create row

Creates a new row in the selected worksheet

Create worksheet - WorkDrive

Creates a new worksheet in Zoho WorkDrive

Create row - WorkDrive

Creates a row in a spreadsheet stored in Zoho WorkDrive

Create spreadsheet

Creates a new spreadsheet

Create workbook from template

Creates a new workbook from an existing template

Update row - WorkDrive

Updates a row in a spreadsheet stored in Zoho WorkDrive

Update row

Updates a specified row in the selected worksheet

Delete row - WorkDrive

Deletes a row in a spreadsheet stored in Zoho WorkDrive

Delete row

Deletes the specified row in a worksheet

Fetch row

Fetches a row by column value

Fetch row - WorkDrive

Fetches a row from a spreadsheet stored in Zoho WorkDrive

Convert currency

Converts the specified value from one currency to another

Fetch historical exchange rate

Fetches the historical exchange rate of a currency for the specified date

Fetch exchange rate

Fetches the latest exchange rate of the specified currency (Will return real-time exchange rate depending on your subscription plan, i.e., updated every 60 minutes, every 10 minutes, or every 60 seconds)

What is Zoho Sheet?

Zoho Sheet is an online spreadsheet application that lets you create, share, collaborate, and publish spreadsheets from anywhere. You can control access to your sheets, change language preferences, and add visuals to represent your data better.

Popular Spreadsheet Zoho

What is Exchangerates API?

Exchangerates API can deliver exchange rate data for more than 170 world currencies with over 15 exchange rate data sources. It can help you receive the latest exchange rate information, convert currencies, and more.

Accounting

Build comprehensive workflows using

Webhook triggers

Receive your data from a wider range of services in multiple formats, like JSON, form data, and plain text.

Learn more >

Logic

Create customized business workflows by including advanced logic elements like if-then branches, time delays, and more.

Learn more >

Custom functions

Write simple scripting functions to format data, call web APIs, send emails, and more.

Learn more >

We started using both from the beginning, but since swapping [to Zoho], we have automated two full-time jobs and outsourced all sales and support roles. It has been huge and we couldn’t imagine going back Know more

Owain ap Rees

Sales Director, Artico

Zoho Flow has automated our entire "Security Operations" process, saving us a lot of manual work and admin overhead, in turn enabling us to focus our efforts on providing clients with accurate and quality services.

Neville Mader

Director, Perth Security Services

With Zoho Flow, we've transformed our feedback process. Automating the creation of tickets in Zoho Desk based on responses from our feedback forms has significantly improved our customer support. The integration with Google Sheets and Zoho Campaigns has also streamlined our communication and marketing efforts. Know more

Toto

Technical Engineer, Master Liveaboards

Watch Zoho Flow in action

Play video

Endless integrations. End to manual work.

SIGN UP TODAY