Get In Touch
Ch. du Vernay 14a
Gland 1196 CH-Vaud
me@haideralleg.com
Ph: +‪41 21 561 28 48‬
Back

Hack of the day: translate directly in a Google Spreadsheet using Deepl Pro API

When did you last feel you found a secret weapon to boost your productivity? For me, it was this week when I discovered you could call the Deepl Pro API inside a Google Spreadsheet.

Switzerland is not your typical country as we handle a lot of languages in our day to day. Switching from English to French is already a challenge; we know that for French people. You add Italian and German and are on for a substantial loss of productivity.

Now, here is a simple tutorial on how I made it:

Setup

  1. In your Google Sheet, from the “Extensions” menu, select “Apps Script” to open the Apps Script editor.
  2. Create a script file named DeepL.gs and copy the contents of the DeepL.gs file in this repo into it.
  3. Modify line 26 of the script to include your DeepL Authentication Key. This line looks like const authKey = "..";, and it comes after the license text.
  4. Close the Apps Script editor and return to your sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *

Login

Login Form

New here? Become a Member to get started!

Subscribe

Membership

About yourself

Let us know who you are to tailor your experience


Membership

Every month access unique content and earn 1 session of coaching with me


Apply Coupon

We care about your privacy

Please read and consent for your data processing.


Have an account? Sign in to continue.