使用应用程序脚本将Google电子表格数据导入Google表单 [英] Import google spreadsheet data into google forms with app script

问题描述

我搜索了互联网，但无法找到对此的回应或文档。
我需要用Google电子表格中的数据动态生成Google表单问题，但我不知道如何引用和阅读电子表格。

I searched the internet and I can't find a response to this nor the documentation for it. I need to dynamically generate Google forms questions with data from a Google spreadsheet using app script, but I don't know how to reference and read a spreadsheet.

推荐答案

这非常简单，请参阅此处： https ：//developers.google.com/apps-script/guides/sheets#reading

It's pretty straightforward, see here: https://developers.google.com/apps-script/guides/sheets#reading

您只需按文档键打开表格，选择数据并将这些单元格作为JS对象读取。

You just need to open the sheet by its doc key, select the data and read the cells as a JS object.

这篇关于使用应用程序脚本将Google电子表格数据导入Google表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！