Gmail Merge from Google Sheet

13 views
Skip to first unread message

Steven Hutchinson

unread,
Mar 11, 2020, 11:03:46 PM3/11/20
to NV Autocrat Add-on
Can AutoCrat perform a Gmail merge to send an email for each row in a Google Sheet and additionally use some of the data in the Google Sheet in the email content?

Joseph Schmidt

unread,
Mar 12, 2020, 2:26:49 AM3/12/20
to nv-autocr...@googlegroups.com
It  should.  Give it a try.



On Wed, Mar 11, 2020 at 11:03 PM Steven Hutchinson <slhu...@daytonpublic.com> wrote:
Can AutoCrat perform a Gmail merge to send an email for each row in a Google Sheet and additionally use some of the data in the Google Sheet in the email content?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/54fe244d-0765-409e-a70e-854651d92073%40googlegroups.com.

Brian McKenzie

unread,
Mar 12, 2020, 7:47:55 AM3/12/20
to nv-autocr...@googlegroups.com
Yes - just make sure all the data is in the same sheet. If you are receiving responses from a Google form you can perform lookups and imports and use the additional data as needed

On Wed, Mar 11, 2020 at 11:03 PM Steven Hutchinson <slhu...@daytonpublic.com> wrote:
Can AutoCrat perform a Gmail merge to send an email for each row in a Google Sheet and additionally use some of the data in the Google Sheet in the email content?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/54fe244d-0765-409e-a70e-854651d92073%40googlegroups.com.


--
Brian McKenzie, Principal
Patrick Fogarty Catholic Secondary School
15 Commerce Rd, Orillia, ON, L3V 0Z2
Twitter: @PrincipalPF
Instagram: @Principal_PF


"We can't be content with knowing the kind of people we are. It matters, too, the kind of people we hope to be." - Anthony Appia

This is a staff email account managed by Simcoe Muskoka Catholic District School Board.  This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender.

Brian Pugh

unread,
Mar 13, 2020, 5:39:36 AM3/13/20
to NV Autocrat Add-on
I would think - unless I've misunderstood you - that Form Mule might be a good choice for this task.

Possible for you to share an example using 'fake' data?

Brian
Reply all
Reply to author
Forward
0 new messages