Have you ever come across a situation, where you need to generate PDF for each row in Google Spreadsheet. Imagine below scenarios. You have an online shop, after customer purchases an item you may require to send pre-filled ordered data in a particular template. Schools and Universities send score cards to students where the template …
Category: Google Script
Share Portion of a sheet in Google Spreadsheet
Google brings us a collaborative spreadsheet interface(the Google Spreadsheet) with tons of features and sharing options. We can share spreadsheets with somebody, protect individual sheets and publish it to web. Still it is lacking a feature which may be useful for its users i.e. share portion of data from a sheet. It comes handy when …
Store Data in Google Spreadsheet in Encrypted Format
It’s very difficult to remember many things which we need on daily basis like passwords, FTP credentials or any other secret data etc. Also it is very dangerous to save those data directly somewhere. We sometimes store our credentials in Google Spreadsheet. But is it really secure ? You never know when somebody peep into …
How to Convert Google Spreadsheet to PDF and Send as Email Attachment
Now a days Google Drive has gain a vast popularity. We have seen people gradually migrating from desktop based office software to browser based Google Sheet and Docs. Sometimes we need Google Sheet data to be emailed to somebody as PDF as email attachment and at times we also want this to happen recurrently. …
Submit HTML Contact Forms in Google Spreadsheet with Notification Email
We use contact forms in our websites and blogs. These are the best and the quickest way our visitors can remain in touch with us. Basically they do two tasks, they store the submitted data in DB and send a notification email to the admin. As we all use Google Spreadsheet and Gmail, so it …