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

Build your own integrations between Zoho Sheet and Exchangerates API

Connect Zoho Sheet and Exchangerates API with over 900+ apps and build your own integrations using our no-code drag and drop builder and comprehensive workflow elements

Supported triggers and actions

Integrate Zoho Sheet and Exchangerates API using the below 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 >

In other words, we use Zoho Flow as the business process designer, where our apps are connected according to the actual, real-life interactions. The most measurable benefit is that we do not have the 'forgotten repairs' anymore. Learn more

Louis Castellano

CEO, Lakeside CNC Group

We use Zoho Flow to connect Zoho Subscriptions with JotForm. As our customers fill their preferences in JotForm, Zoho Flow passes it to Zoho Subscriptions and creates a subscription automatically. It was impressive that we were able to configure all this on a simple drag-and-drop interface!

Josh Lucas

Head of Operations, AAA Band Rentals

Fabricroot's manual process of maintaining and managing inventory was then automated using Zoho Flow. Without Zoho Flow, the project would have taken longer to integrate and encountered unknown challenges. Zoho Flow now acts as the backbone of their online business. Learn more

Harnoor Abroll

Technical and Operations Head, TruAct

Watch Zoho Flow in action

Play video

Endless integrations. End to manual work.

SIGN UP TODAY