Table of Contents
What does it do?
Do you often have a need to display currency conversions in your Google Workspace emails, Docs, Sheets, Slides or Calendar?
Are you a little annoyed that you have to head over to an external site or jump onto Google each time to make a conversion – copy it – head back – and then paste it into your document?
Currency Converter seeks to solve this problem by providing a currency conversion right inside your Google Workspace environment. It is hoped that Currency Converter will help you to recapture some much-needed time in your busy work life.
Currency Converter allows you to convert currencies based on daily exchange rates right in your Google Workspace sidebar. You can even modify the currency conversion to your own preference or region.
How does it work?
Currency Converter is simple and easy to use.
After you have installed the free add-on from Google Marketplace, simply click the icon on the right sidebar and accept the non-intrusive authorisations.
- Select your currency from
- The amount you want to convert
- The currency you want to convert to.
- Hit Submit
Your conversion will appear below for you to select and copy and paste into your Google Document, Gmail, Sheet, Slide or Calendar details.
Why doesn’t the conversion result just automatically load into my document?
I definitely could have created that functionality, but this would require greater scope and edit access to your documents. I wanted to have the least amount of scopes and access possible for your peace of mind and privacy. And really a quick-select and copy and paste is not a lot of work.
Want a different format of the conversion? Want to save your preferences?
I’ve got you covered.
Customizing your currency conversion results.
You can change how you want your currency conversion results to be displayed by accessing the advanced options.
Just before the Submit button, you might have noticed the little down arrow or
'v'. Click on that to expand the options.
This will reveal the advanced options. You can:
- Change the display pattern.
- Choose to add the currency symbol or not.
- Choose the locale format (Some countries use commas and periods differently to separate numbers or identify decimal numbers).
You can also save all these input values as default for the next time you need to use Currency Converter.
Where does the currency data come from?
Currently, the currency data is extracted directly from the European Central Bank. The European Central Bank updates its latest conversion rates daily around 4 pm CET and Currency Converter tries to capture this update as soon as it appears.
Support my projects.
If you have found Currency Converter useful why not shout me a coffee? Not only does it help pay for the maintenance of this site, it also encourages me to build more free tools for you so that I don’t have to hide behind a paywall.
Feedback: What to add next.
Don’t see an option you really need? Want to see some other features in Currency Converter? Found a bug?
Let me know.
I would love to hear your thoughts to help this add-on improve and better support you. Go ahead and fill out the form below. If I get a lot of requests for the same thing I will prioritize it for implementation into the next version.
Terms and Conditions
Terms and Conditions (“Terms”)
Last updated: (20 July 2021)
Please read these Terms and Conditions (“Terms”, “Terms and Conditions”) carefully before using Currency Converter referred to as the “service” operated by Yagisanatode (“us”, “we”, or “our”).
Your access to and use of the Service is conditioned on your acceptance of and compliance with these Terms. These Terms apply to all visitors, users and others who access or use the Service.
By accessing or using the Service you agree to be bound by these Terms. If you disagree with any part of the terms then you may not access the Service.
Our Service allows you to fetch and display currency rate data from a Google Workspace Add-on sidebar. Currency data is drawn from:
- Daily updates from the European Central Bank.
While every attempt is made to provide accurate currency exchange data. Yagisanatode does not take responsibility for the accuracy of the data. You are responsible for the outcome of the data and any loss of data or format that may result after the use of the Add-on.
Links To Other Web Sites
Our Service may contain links to third-party websites or services that are not owned or controlled by Yagisanatode.
Yagisanatode has no control over and assumes no responsibility for, the content, privacy policies, or practices of any third-party websites or services. You further acknowledge and agree that Yagisanatode shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, goods or services available on or through any such web sites or services.
We reserve the right, at our sole discretion, to modify or replace these Terms at any time. If a revision is required we will try to provide at least 30 (change this) days notice prior to any new terms taking effect. What constitutes a material change will be determined at our sole discretion.
If you have any questions about these Terms, please use the Contact Us form provided here.
Currency Converter adheres to the Google API Services User Data Policy.
Currency Converter only collects the user’s country locale data so that it can customise the currency location of the user. No other personal data is collected.
Your locale data is not sent to any 3rd party and remains exclusively in the Currency Converter app.
The only information that is stored in Currency Converter are the selections that you make and your choice to set these selections to default. Saved default settings are stored in the User Property of the Google Apps Script Property Service. Your selections are not accessible by the author of Currency Converter, 3rd parties or other users.
Saved default settings include your selected:
- Currency from
- Currency to
- Exchange layout
- Option to add currency character
3rd Party Access
Currency Converter relies on an XLM list of currencies from the European Central Bank. Data is only fetched if there are new currency rates available. This data is transformed into a JSON file and save in Script Property of the Properties Service for all users of the App to use so as not to call the European Central Bank too many times.
No data is sent out from the App to third parties.
Currency converter uses the following scopes:
https://www.googleapis.com/auth/calendar.addons.execute– Run as a Calendar add-on (non-sensitive): Used to add the Currency Converter add-on to the calendar sidebar.
https://www.googleapis.com/auth/gmail.addons.execute– Run as a Gmail add-on (non-sensitive):
- Used to add the Currency Converter add-on to the Gmail sidebar.
https://www.googleapis.com/auth/script.locale– View your country, language, and timezone (non-sensitive): Used to access your country locale to set up currency conversion.
https://www.googleapis.com/auth/script.external_request– Connect to an external service (sensitive): Used to fetch currency conversion data from the European Central Bank.
Google APIs Used
The following APIs are used in conjunction with Google Apps Script ( The development language of the Add-on):
CardService – to build the user interface for the Google Workspace Add-on
PropertiesService – To store currency and user preference data.
UrlFetchApp – To fetch exchange rate data from the European Central Bank.
XmlService – To convert XML data to JSON.
Session.getActiveUserLocale() – Your locale.