且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

按需复制Google电子表格

更新时间:2022-10-16 08:38:47

几个选项:


  • 与其强制用户创建验证的电子表格,您可以通过电子邮件发送表单来填写 Google表单,并将回答汇总回来在您的电子表格中。

  • 使用docs API =nofollow noreferrer>复制文档。

  • 使用 Google Apps Script 让流程自动化(本质上是javascript)。
  • >

I've created a pretty complex Google spreadsheet. I would like a user to be able to click a button or follow a link, and get a copy of this spreadsheet where they can fill in data. I would later check process this data manually.

Is there anyway I can do this via a complicated link, or some Javascript, or possibly even using a server side language (e.g. Python, Java).

Thank you,

You have a few options:

  • Rather than force a user to create a spreadsheet that you verify, you can email them a form to fill out with Google forms, and the answers get aggregated back on your spreadsheet.
  • Use the docs API to copy documents.
  • Use Google Apps Script to automate the process (it's essentially javascript).