{"id":1232,"date":"2020-06-14T15:50:22","date_gmt":"2020-06-14T15:50:22","guid":{"rendered":"https:\/\/sp2hari.com\/?p=1232"},"modified":"2020-06-14T15:50:22","modified_gmt":"2020-06-14T15:50:22","slug":"mail-merge-to-pdf-files-v2","status":"publish","type":"post","link":"https:\/\/sp2hari.com\/index.php\/2020\/06\/14\/mail-merge-to-pdf-files-v2\/","title":{"rendered":"Mail Merge to PDF Files – V2"},"content":{"rendered":"\n

This is a follow up of the post I’ve shared earlier to create files earlier at https:\/\/sp2hari.com\/mail-merge-to-pdf-files\/<\/a><\/em><\/p>\n\n\n\n

While the first version of the post I made for creating multiple PDF files from Google Doc and Google Sheets still works, it is a lot hackerish<\/em>. Copying the ID from the document, and managing the ‘Config’ in the sheet is a lot of work. One can easily make a lot of mistakes while copy-pasting. Also, the user (I have only one so far) I had testing this script was very reluctant to run the script because of the overhead involved in managing these difficult document id and folder id. I realized I had to make the process much easier for someone to run the script. Hence the v2 with the settings option. <\/p>\n\n\n\n

Step 1: Create a new Google Sheet<\/h4>\n\n\n\n

Open the sheet\u00a0https:\/\/docs.google.com\/spreadsheets\/d\/1ltQ0eQcmK_pztv0Bb8diJIzIr3YSMGU3soF-i6Bcmo4\/edit?usp=sharing<\/a>\u00a0and create a copy of the sheet using \u2018File -> Make a copy\u2019 option.<\/p>\n\n\n\n

Step 2: Create the template Google Doc<\/h4>\n\n\n\n

Open the document https:\/\/docs.google.com\/document\/d\/1yAk0C5I-ycHxMB8jA3Anpu8LNLLKzxtu8N6PM5FG8H8\/edit?usp=sharing<\/a> and create a copy of the doc using \u2018File -> Make a copy\u2019 option. Copy the entire URL of this Google Document. We will need this later (to be used as ‘Template Link’)<\/p>\n\n\n\n

Step 3: Create the output Google folder<\/h4>\n\n\n\n

Create a new empty folder in your Google Drive. This will be the folder where we generate the files. Copy the URL of this folder as well. We will need this later too (to be used as ‘Output Folder’)<\/p>\n\n\n\n

Step 4: Create Google Apps Script<\/h4>\n\n\n\n

When you make a copy of the Google Sheets file, it automatically clones the script along with it. So you can avoid this step if you cloned the Google Sheet in Step 1. If you want to find the code powering this script, you can find it by following the option \u2018Tools -> Script Editor\u2019. The latest version of the code will be also be maintained at https:\/\/gist.github.com\/sp2hari\/75334431913719f204030753da4eef2d<\/a>. <\/p>\n\n\n\n

Step 5: Run the script<\/h4>\n\n\n\n
\"\"
Settings option under the Jetpack menu<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Authorization needed to run script – Need to do this first time only.<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Again, need to do this first time only.<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Again, need to do this first time only.<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Setting options with no details updated<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Settings option with template link, output folder and file name filled in.<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Success message after settings is published.<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Sample Data<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
The final bliss message!<\/figcaption><\/figure><\/div>\n\n\n\n

There is one interesting image on how to build an MVP that comes back to my mind looking at the v1 and v2 post. The earlier version had the hackish ‘Config’ sheet with which you had to manage the settings. It still works, but not easy to work with. You had to do a lot of hard work to make it happen. The v2 has this much better looking ‘Settings’ option to manage the Config details. It makes the job easier and has a bunch of error handling added to the settings page. Looking forward to the v3, v4, and v5. <\/p>\n\n\n\n

\"\"
How to build an MVP.<\/figcaption><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"

This is a follow up of the post I’ve shared earlier to create files earlier at https:\/\/sp2hari.com\/mail-merge-to-pdf-files\/ While the first version of the post I made for creating multiple PDF files from Google Doc and Google Sheets still works, it is a lot hackerish. Copying the ID from the document, …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-1232","post","type-post","status-publish","format-standard","hentry","category-code"],"_links":{"self":[{"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/posts\/1232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/comments?post=1232"}],"version-history":[{"count":16,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions"}],"predecessor-version":[{"id":1260,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions\/1260"}],"wp:attachment":[{"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/media?parent=1232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/categories?post=1232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sp2hari.com\/index.php\/wp-json\/wp\/v2\/tags?post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}