ttsukagoshi/sheetsl

Google Sheets add-on to use DeepL translation. Translate the contents of the selected range and paste them in the range of cells adjacent to the original range.

SheetsL - DeepL Translation for Google Sheets

Google Sheets add-on to use DeepL translation. Translate the contents of the selected range and paste them in the range of cells adjacent to the original range.

How to Use

Install the add-on from the Google Workspace Marketplace. For details, see the add-on's web page.

Terms and Conditions

You must agree to the Terms and Conditions (TaC) to use this add-on. The disclosure on privacy and OAuth scopes constitutes part of this TaC.

Attributes

The original icon of this add-on is the Document icons created by Freepik - Flaticon, modified by ttsukagoshi.

sheetsl's Issues

Crash with cells with too much text - unknown limit...?

Got an error when there is too much text to translate in one cell, but limit is unknown to the user

Add Jest test for translateRange

Breaking down the remaining actions of #31

Switch to Typescript

Update CodeQL settings file to latest format

Update Super Linter settings file `linter.yml` to latest format

Fix typo in error message on translation

[SheetsL] Target Language Unavailable: Set the target language at the Settings > Set Lanuguage of the add-on menu.

↓

[SheetsL] Target Language Unavailable: Set the target language in Settings > Set Language of the add-on menu.

Number of columns do not match

Add Jest testing

Error after first installation

I had an already opened existing google sheet. I installed the app, set the api key, then I tried to set the language but got an error. Closed Chrome, restarted te same google sheet and then it was possible to set the language.

URLFetch URL length exceeds limit

Add Jest test for setLanguage

Breaking down the remaining actions of #31

Add a common function to handle error reponse codes in DeepL API

https://www.deepl.com/docs-api/api-access/error-handling/

Use payload to translate text in calling the DeepL API

See GASでDeepL APIを使ってみた | GMOアドパートナーズ TECH BLOG byGMO

Setting input language as blank for DeepL autodetection returns an error message

Add Jest test for deleteDeeplAuthKey

Breaking down the remaining actions of #31

Add Jest test for setDeeplAuthKey

Breaking down the remaining actions of #31

Empty cells not working

Hi man, nice job, testing it on google sheet. When I try a translation on multiple cells I get an error if among the cells some of them is empty.

Update .prettierrc to reflect Prettier v3 default values

Re #112

Error is returned in some translation cases where ROW_SEPARATER is truncated in the DeepL translation

Add documentation on README

Update actions/setup-node settings `with.node-version` v16 -> 20

Group dependabot updates for @typescript-eslint packages

Add accessibility-alt-text-bot

Enable github/accessibility-alt-text-bot: An action to remind users to add alt text on Issues, Pull Requests, and Discussions on repository workflow.

See Make your GitHub projects more accessible with accessibility-alt-text-bot | The GitHub Blog for more details

Add menu item to check usage status