CODEWITHSUNDEEP
emailgoogle-apps-scriptgoogle-sheets
Tom
Tom

Reputation: 65

Insert data into a google spreadsheet via a link

I'm looking for a way for users to send data from an email sent to them in a single click using google scripts.

Basically, I have a spreadsheet with a list of emails, and I want to send an email to all of them (I've already set up a sort of mail merge script).

The tricky part is that I want the emails to contain links unique to each person. If they click one of the links, I want data to be entered into the spreadsheet in the row corresponding to their email address.

Is this at all possible?

Upvotes: 1

Views: 2235

Answers (1)

rGil
rGil

Reputation: 3719

I posted this response to basically the same question a few weeks ago. It uses the technique described by Henrique in the above comment to use an item from the individual row as a parameter in the webapp url.

Upvotes: 2

Related Questions