通过链接将数据插入Google电子表格 [英] Insert data into a google spreadsheet via a link

问题描述

我正在寻找一种方法，使用户可以使用Google脚本通过一次单击就从发送给他们的电子邮件中发送数据.

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.

这有可能吗?

推荐答案

我对基本相同的问题发布了此回复几周前.它使用Henrique在上面的注释中描述的技术，将单独行中的项目用作webapp网址中的参数.

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.

这篇关于通过链接将数据插入Google电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！