I wonder if it is possible to create a custom printable view from a google spreadsheet.
– Suppose we have a single table in a google sheet.
– Our table columns are as follow: First column->Date and time of the record // Second column->Last Name // Third column->First Name // Fourth column->E-mail address // Fifth column->Books quantity // Sixth column->Glasses quantity etc. So we have records just like this:
1/12/2014-13:05:07 // Smith // John // johnsmith@yahoo.com // 14 // 0
2/12/2014-14:06:08 // Kliafa // Ardea // kliafa_Ard@gmail.com // 3 // 4

In our printable view we need to re-arange the data and we need to omit some of them. Let’s say we need to omit the zero columns per person and the Email addresses. So, we need something like this:

NAME: Smith, John
Date: 1/12/2014-13:05:07
Books: 14
NAME: Kliafa, Ardea
Date: 22/12/2014-14:06:08
Books: 3
Glasses: 4

So, is this customization possible? Is there such choices in google sheets or we need to look up for a gs script? And is it an easy task?

I will appreciate any help
Thank you

I have a wordpress based site and use contact form 7. The emails that I get thru form submissions have from email address as wordpress@mysite.com and reply-to address as the senders email id.

So can you tell me what changes do I need to make to extract reply-to emails from these mails using your email extractor script ?


I’m using boomerang email scheduling service (http://www.boomeranggmail.com/). Is there a way to combine this to.

If this is not possible; can mail merge save personalized messages as drafts instead of sending them ?

thank you


I love this Google Sheet approach to scheduling gmail messages, and I’ve been using it quite a bit.

“How to Schedule your Gmail Messages with a Google Sheet”


I’ve noticed, though, that the messages sent by the scheduler come from the address of my gmail account rather than the address of the account that gmail is accessing via a POP server. The “reply-to” is the POP address, but not the “from”. Is there any way to have messages sent by the scheduler be from the POP address rather than from the gmail address?




I just found and tested your Google docs mail merge spread sheet. Is there any way to integrate this with email tracking like Signals by Hotspot?



Hey Amit, I have a quick question and am hoping you can help me out. I have been using your Amazon Price Tracker and love it. However, I did notice that it tracks the lowest price of the selected product. Is there a way to change the tracker to follow the main price (just the one that is seen when opening the Amazon page), instead of searching for cheaper prices from other sites?


Hi wonder if you can help me. I set up your free archiver and it certainly works! However i noticed that it did not pick up some tweets/retweets from earlier in the day. Our competition started at 08h00 and the feed missed earlier tweets. Is there a reason for this? How can I ensure that when I run a competition it picks up all the tweets/retweets?

Many thanks! Great tool – really helped us


Its been 2 days and i have mailed you 3 times – M interested in google mail merge script – premium. M trying to make payment via paypal but couldn’t do so because m from India. Can you please help me by answering my question.

1) Can i include personalize attachment to every email id. I mean not same attachment to every recipient. Unique attachment to every recipient – Is it possible with your script.

2) I went through your video in that you have mentioned that we have to upload file in google docs – open that file and then take attachment ids and paste in mail merge script. So if m going to upload bulk files then do i need to open every file and get there id?

3) How accurate email open rates tracking – Will i be getting instant alert if someone open emails – will i be getting details like which recipient opened and his location.

4) Is it possible to schedule mail merge for recipient who are in different time zone.

Please help me with some other form of making payment in friendly way.


Hello, first of all thank you for sharing so many useful script with us.

Here is my question:

We have a form that requires the user to upload two documents before submitting the request. We are currently implementing one of the ideas found on your site to do this: we created separate links so that they can upload the files to our account. However, sending the user to visit two separate pages to submit the documents and then return to the original form to submit the request, doesn’t seem like the most efficient way to do it.

Do you know of any way we could make this as an editable region in the form itself?

Here is the link to the form I am referring to, so that you can have a better sense of what we mean: