英文:
How can I track Google Forms responses without requiring manual email submission?
问题
Pretext: 我对编程和Google API非常陌生。
我目前正在进行一个项目,需要跟踪Google表单的每个受访者的发送和提交接收情况。挑战在于,我不想让受访者手动提交他们的电子邮件,因为我已经在客户数据库中存储了他们的电子邮件地址,以及每个客户的唯一标识符。
为了给您一些背景信息,这些调查是通过电子邮件发送的,我想找到一种方法来修改Google API,记录每个调查何时发送到每个电子邮件,以及在提交时识别调查响应。
我已经尝试了各种方法,但尚未找到直接的解决方案。我考虑过使用Google Apps Script或Google Forms API,但不确定实现我的目标的最佳方法。
如果有人在不需要手动提交电子邮件的情况下跟踪Google表单中受访者活动方面有经验或知识,我将非常感谢您提供的任何指导、建议或见解。具体来说,我想知道是否有任何方法可以修改Google API以记录电子邮件的发送并将其与调查响应关联起来。
提前感谢您的帮助!
诚挚地,
一个启动者。
我在互联网上找到了一个可以将Gmail文件夹的内容导出到Google表格的工作脚本。我尚未能够设置它来监视已发送文件夹,但由于电子邮件只会发送调查,这可以记录调查的发送。
然而,这不允许跟踪已完成的调查。我了解可能有一种方法,可以使用包含UID的隐藏字段,并且可以根据所选择的电子邮件生成预填充链接,但我不知道从哪里开始使用这种方法...
英文:
Pretext: I am very new to programming and google api.
I'm currently working on a project where I need to track the sending and submission receiving of each respondent of a Google Form. The challenge is that I don't want to make the respondents manually submit their emails because I already have their email addresses stored in a customer database, along with unique identifiers for each customer.
To give you some context, the surveys are sent out via email, and I want to find a way to alter the Google API to record when each survey is sent out to each email, as well as identify the survey responses as they are submitted.
I've explored various approaches, but I haven't found a straightforward solution yet. I've considered using Google Apps Script or the Google Forms API, but I'm unsure about the best approach to achieve my goal.
If anyone has experience or knowledge in tracking respondent activity in Google Forms without requiring manual email submission, I would greatly appreciate any guidance, suggestions, or insights you can provide. Specifically, I would like to know if there are any methods to modify the Google API to record the email sending and associate it with the survey response.
Thank you in advance for your help!
Sincerely,
A Bootstrapper.
I found a working script off the internet that can export the contents of a gmail folder to a google sheet. I haven't been able to set this up to monitor the sent folder, but since the email will only be sending surveys out, this could record the sending out of surveys.
This does not allow tracking for the completed surveys, however. I understand their may be a way to have a hidden field containing the UID, and that a pre-filled link can be generated based on the email chosen, but I wouldn't know where to start with this method...
答案1
得分: 1
以下是翻译好的部分:
-
如果您的客户不想手动输入他们的电子邮件地址,作为替代方法,我可以为您提供在Google表格中创建一个预填充URL的公式,以便它已经包含了他们的电子邮件地址(或任何其他您想要的标识符)。
-
在您的Google表格编辑器中创建您的Google表单,包括“电子邮件”地址或您想要使用的任何其他ID字段。接下来,我们需要收集要填充答案的问题的“输入ID”。
-
在您的Google表单编辑器中,点击顶部的3个点,然后选择“获取预填充链接”。
-
它将打开您的表单的“视图”版本,在这里您可以填写以后要自定义的参数,滚动到底部找到“获取链接”并复制该链接,我们将在下一步的公式中使用它。
-
链接将具有以下结构:
https://docs.google.com/forms/d/e/1YOUR-FORM-ID/viewform?usp=pp_url&entry.1418014325=email@example.com
复制直到等号(=)之前的所有内容,使其看起来像这样:
https://docs.google.com/forms/d/e/1YOUR-FORM-ID/viewform?usp=pp_url&entry.1418014325=
-
在包含客户数据的Google表格中,我们将粘贴以下公式,但进行一些更改:
公式
=ARRAY_CONSTRAIN(ARRAYFORMULA({"预填充表单URL"; hyperlink("在此粘贴来自上一步的URL="&$C$2:$C&""","自定义URL")}),counta($C1:$C),1)
更改
确保更新您选择的标识符所在的范围。
一旦您修改了公式以匹配您的数据,它应该生成类似于这样的链接。
我添加了我创建的文件,我在其中测试了这个解决方案:https://docs.google.com/spreadsheets/d/1uLE-bp6aZsr41JatgQalWfKLlwKHsrK4TTa5esxmwuo/edit?resourcekey#gid=1351399216,希望这能让您更接近您想要实现的目标。如果您有任何问题,请告诉我,我会尽力帮助您:)
英文:
As an alternative if your customers don't want to type their email addresses manually, I can provide you with a formula for creating a prefilled URL in Google Sheets, so it already contains their email address (or any other identifier you want).
- Create your Google Form including the field for the ‘email’ address or any other ID you would like to use.
Then, we need to gather theentry id
for the question we will be pushing the prefilled answer. - In the editor of your Google Form click on 3 dots at the top and select "Get pre-filled link"
3.It will open a view
version of your form, where you can fill the parameter you want to customize later, scroll all the way down to "Get link" and copy the link, we will use it for the formula in the next step:
-
The link will have the following structure
https://docs.google.com/forms/d/e/1YOUR-FORM-ID/viewform?usp=pp_url&entry.1418014325=email@example.com
Copy everything until the=
so it will look like thishttps://docs.google.com/forms/d/e/1YOUR-FORM-ID/viewform?usp=pp_url&entry.1418014325=
-
In a Google sheet where you have your customer's data, we will paste the formula, but making some changes:
Formula
=ARRAY_CONSTRAIN(ARRAYFORMULA({"Prefilled form URL"; hyperlink("PASTE-HERE-THE-URL-FROM-PREVIOUS-STEP="&$C$2:$C&"","Custom URL")}),counta($C1:$C),1)
Changes
Make sure to update the ranges where the identifier of your choice is located
Once you have modified the formula to match your data it should generate links like this:
I'm adding the file I created where I tested this solution: https://docs.google.com/spreadsheets/d/1uLE-bp6aZsr41JatgQalWfKLlwKHsrK4TTa5esxmwuo/edit?resourcekey#gid=1351399216
hopefully this gets you closer to what you are trying to achieve. If you have any questions, let me know and I'll see what I can do
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论