theghostbel/gdocs-table-downloader

Use Google Spreadsheet as storage for your app translations. Or use this npm package to download your google spreadsheets as JSON files with just a single call.

Hi there 👋!

I am Victor Rusakovich, client-side developer from Minsk, Belarus

• 🔭 I’m currently working at GP Solutions (since August 2011, 4214 days!)
• 🌱 I’m currently learning JavaScript
• 📫 [email protected] (please, no spam)
• LinkedIn
• ⚡ Fun fact: Thirty-five percent of people who use personal ads for dating are already married.

FrontEnd conferences and me

I like to present some topic at FE conferences at least once a year. Subscribe to RSS feed with the latest updates.

Latest videos

🔢	📅	📷	Youtube playlist
1	January 9, 2023		[Neil deGrasse Tyson
2	October 10, 2022		Как проработать 11 лет в одной компании и не потерять интерес – Виктор Русакович – Frontend Weekend
3	August 19, 2021		Круглый стол "Хорошие практики современного фронтенда"
4	August 19, 2021		Сбор и анализ производительности у клиентов / Виктор Русакович
5	April 14, 2020		Пусть всем кажется, что всё грузится быстро / Виктор Русакович (GP Solutions)
6	December 9, 2019		Пусть всем кажется, что всё грузится быстро, Виктор Русакович
7	March 29, 2019		Elm — new language, new you, Victor Rusakovich [CSS-Minsk-JS 2018]
8	February 22, 2019		Зачем мы переписывали приложение на Elm и кто за это ответит / Виктор Русакович
9	December 14, 2018		Зачем мы переписываем приложение на Elm, и кто его знает? / Виктор Русакович (GP Solutions)
10	June 23, 2018		Фронтенд без боли, ошибок и Javascript. Все про Elm. Функциональное программирование
11	January 16, 2018		Тестируй это / Виктор Русакович (GP Solutions)
12	November 3, 2017		Виктор Русакович - Выборы, выборы, все фреймворки… приторны
13	May 23, 2016		JavaScript: прошлое, настоящее и будущее, Владимир Дашукевич
14	February 10, 2016		Party Hard! 2016 - техническая секция, часть шестая
15	July 13, 2015		Непрерывная интеграция или „Кто всё сломал?“
16	July 3, 2015		MoscowJS 23 — Непрерывная интеграция или "Кто всё сломал? — Виктор Русакович
17	June 4, 2015		Continuous Integration — A to Z или Непрерывная интеграция — кто всё сломал?, Виктор Русакович
18	February 22, 2015		Solit 2012. Виктор Русакович. "Беспроблемное внедрение js/css/html на сторонних ресурсах"
19	May 5, 2014		Solit 2014. Виктор Русакович. "Реактивный JavaScript. Победа над асинхронностью и вложенностью"
20	May 5, 2014		Solit 2014. Виктор Русакович. "Непрерывная интеграция сложного проекта. Кто всё сломал?"

gdocs-table-downloader's Issues

DX: Add githooks

Support auth via keys.json

When creating service account you can download a json key file:

{
  "type": "service_account",
  "project_id": "gdocs-table-downloader",
  "private_key_id": "25ee4ca290ddbc02a4330d0a342e18dd42a97b63",
  "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
  "client_email": "[email protected]",
  "client_id": "123456789012345678901",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/service-account%40gdocs-table-downloader.iam.gserviceaccount.com"
}

Should add a new login type to provide this key file for performing a login

Convert to TypeScript

Show warning when the title of "key" column is missing

If someone removes key column title by accident then the script generates empty js files. It would be nice to have some warning if a similar situation happens

Expose internal API

Instead of saving translations, let's return the whole object, so GTD users can decide what to do with their data.

Support options from js file

customOptions file can be already used, but only for auth and custom value mapper. And passing all required options to a command line makes the launch string pretty long.

Add "json" export format

The current version supports moduleType as AMD and ESM. Should also be able to return a pure JSON file.

Empty cells cause translations override

Update README.md

• general information
• link to test google file
• config details

Use native google api instead of google-spreadsheet

Seems like google-spreadsheet (being a nice project though) creates extra queries to Google. Sometimes it may result in quota shortage.

The task is to use googleapis and get all data in one or two calls:

• one call: if we don't put sheets list and all sheets are downloaded
• two calls: when setting sheets list at first we request spreadsheet title and gridProperties (with includeGridData: false), and then we request with includeGridData: false only the data in required sheets.

DX: Add prettier

Sheets argument is broken

Setting "sheets" argument does not work and all sheets are downloaded

Add eslint mute only by request

Add an option that will disable adding eslint "mute rule" to the ESM and AMD files.