Dokin lets you create multiple documents for each row of your Google Sheets database variables.

‍

Once you have created a database variable in your Google Sheets, you can export it to your Google Slides and/or Google Docs.

‍

You will be able to add each header of your database as content of your documents.

‍

1 - You can click on the button “Mail Merge”

‍

2 - select your database

‍

3 - You can insert the placeholder values at the place where you want your data to be inserted. Click on the header you want to insert. You can also type directly in your documents. For example, if you have a column with the header “Name”, type {{Name}} everywhere you want the name to be inserted. 

‍

‍

‍

4  - Once you have completed inserting your variables, you can move on the Options by clicking on the next “>” button on the top right of the add-on. 

‍

4.1 - You can select the folder in which you want the generated documents to be stored. 

‍

4.2 - Select the title of your generated documents. You can also insert headers within the title. 

‍

4.3. Select for which lines of your database you want to create a document. 

‍

4.4. Select the type of output document you want. You can either generate a PDF, or generate editable Google Slides or Google Docs. 

‍

‍

‍

5 - Optional. You can directly send your documents from within Dokin. In the recipient input, enter the header in which the email addresses are, for example : {{email}}. You can also add a title and a content to your email. When you type ‘{{‘ the list of all headers appear. Click on it to have it inserted effortlessly. 

‍

‍

6 - You are now ready to generate your documents. Click on the “Create documents” button. You will receive a notification once your documents have been created and or sent via email. 

‍

‍