Register on https://www.deepl.com/en/pro-api for free or your professional API key and generate your personal key on https://www.deepl.com/en/your-account/keys afterwards. If you are part of a company using the DeepL™ Enterprise solution ask your admin for a personalized API key.
You can purchase your lifetime license key here https://patrickspark33.gumroad.com/l/bpetf . After purchasing you will receive an email from Gumroad instantly with your key informations.
Install Context Translator Pro 2 from the Google Marketplace™ into your personal Google Account
Launch the Context Translator Pro 2 add-on from the right sidebar or via the "Extensions" menu in your Google Sheet™. Open the ⚙️ API Settings & License area within the add-on, paste your license key (from step 2) and your DeepL™ API key (from step 1), and hit save settings.
Select the cells you want to translate in the spreadsheet, choose your preferred languages and additional configurations like context and glossary and hit translate selected cells. The translations will appear instantly in the next or your defined column.
Keep always control of your credits and costs (500K chars per month included in DeepL™ free plan) with Context Translator Pro 2
Disclaimer: Context Translator Pro 2 is an independent third-party application and is not affiliated with DeepL SE or Google LLC. DeepL™ is a trademark of DeepL SE. Google Sheets™ is a trademark of Google LLC.