Skip to content

fertkir/vocabulary-to-google-sheet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

What is it for?

Watch in this video. Suppose you're learning a language, how do you remember new vocabulary? There're beliefs that the best approach is to read a sentence which has a new word in it.

For example, you want to remember a word car. You open an online dictionary and see these examples:

  • I have a car of BMW brand.
  • You drive your car too fast.
  • What color is your car?

What would you do with these? I would save them to my vocabulary Google Sheet and read them on the next day. But copy-pasting each sentence isn't cool, especially on your smartphone =(

This browser extension allows you to have those sentences to look like this in your browser:

  • I have a car of BMW brand. [Save]
  • You drive your car too fast. [Save]
  • What color is your car? [Save]

Where [Save] is a link. When you click it, the sentence is saved to your Google Sheet. Isn't that cool? =)

I like it! But what do I do with those sentences in a Google Sheet?

There's a nice Google Sheet add-on that will automate the learning process. Once you've saved the sentences, you'll periodically receive emails with them to recollect. More details how the Google Sheet add-on works, what it does and how often does it send emails can be found in the add-on description.

What online dictionaries are supported?

The full list can be found here, among them are:

Since sentences detection is based on regular expressions, it would be quite fast to add support of other dictionaries.

How to get it?

For desktops

For Android

Google Chrome's extension is supported by the following browsers on Android (read this manual how to install it):

For iPhone

Unfortunately, iPhone doesn't support browser extensions. But Vocabulary 90 add-on supports adding sentences through a Google Form (see screenshots here). Currently, it's the most convenient way of adding sentences for iPhones.

How to install the extension and how to setup a target Google Sheet for it, please read here.

How to build the source code

Requirements

  1. Ubuntu or other Linux distribution.
  2. jq v.1.5.1 (sudo apt install jq) - for merging manifest.json for different extension distributions.
  3. zip - to create archive of extension
  4. make

Building process

Run make

Built extensions will be in build/ directory.