blocks|key|46959|text|如果您只想知道如何构造post请求，请查看此示例|type|unstyled|depth|inlineStyleRanges|entityRanges|data|46960|http://nodejs.org/api/http.html#http_http_request_options_callback|offset|length|46961|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1U|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

If all you want to know is how to construct post request, then check this example 

<a href="http://nodejs.org/api/http.html#http_http_request_options_callback" rel="nofollow">http://nodejs.org/api/http.html#http_http_request_options_callback</a>

blocks|key|45970|text|结帐|type|unstyled|depth|inlineStyleRanges|entityRanges|data|45971|https://github.com/EastCloud/node-spreadsheets/|offset|length|45972|EastCloud为Google+Docs/Drive+API编写了一个友好的包装器|45973|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1B|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Checkout

<a href="https://github.com/EastCloud/node-spreadsheets/" rel="nofollow">https://github.com/EastCloud/node-spreadsheets/</a>

EastCloud has written a friendly-ish wrapper around the Google Docs/Drive API

blocks|key|2523718|text|下面是如何使用Google+Sheets+API+(当前为v4)的create方法完成此操作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2523719|此代码示例不使用任何第三方库，它使用googleapis:+Google+API's+official+Node.js+client|2523720|const+google+=+require('googleapis');
const+sheets+=+google.sheets('v4');

//+authenticate,+and+store+that+authentication,+in+this+example
//+it+is+stored+in+a+variable+called+`auth`.+I+am+using+JWT+
//+authentication,+but+you+can+use+the+any+form+of+authentication

const+auth+=+new+google.auth.JWT(
++key.client_email,
++null,
++key.private_key,
++['https://www.googleapis.com/auth/spreadsheets'],+//+make+sure+that+your+auth+scope+includes+`spreadsheets`,+`drive`+or+`drive.file`
++null
);

sheets.spreadsheets.create({
++auth:+auth,
++resource:+{
++++properties:+{
++++++title:+'Title+of+your+new+spreadsheet'
++++}
++}
},+(err,+response)+=>+{
++if+(err)+{
++++console.log(`The+API+returned+an+error:+${err}`);
++++return;
++}

++console.log('Created+a+new+spreadsheet:')
++console.log(response);
});|code-block|syntax|javascript|2523721|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/sheets/api/guides/concepts|1|https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create|2|https://www.npmjs.com/package/googleapis^0|X|6|7|H|0|X|6|1|0|I|A|I|1C|2|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]|$9|14|A|15|1|16]]|E|$]]|$1|F|3|G|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@$9|1A|A|1B|1|1C]]|E|$]]|$1|H|3|I|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]|U|$5|P|Q|R|E|$S|V]]|W|$5|P|Q|R|E|$S|X]]]]

Here is how to do it with the <a href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create" rel="nofollow noreferrer"><code>create</code></a> method of the <a href="https://developers.google.com/sheets/api/guides/concepts" rel="nofollow noreferrer">Google Sheets API</a> (currently v4).

This code examples does not use any 3rd party libraries, it uses <a href="https://www.npmjs.com/package/googleapis" rel="nofollow noreferrer"><code>googleapis</code>: Google API's official Node.js client</a>

<pre><code>const google = require('googleapis');
const sheets = google.sheets('v4');

// authenticate, and store that authentication, in this example
// it is stored in a variable called `auth`. I am using JWT 
// authentication, but you can use the any form of authentication

const auth = new google.auth.JWT(
 key.client_email,
 null,
 key.private_key,
 ['https://www.googleapis.com/auth/spreadsheets'], // make sure that your auth scope includes `spreadsheets`, `drive` or `drive.file`
 null
);

sheets.spreadsheets.create({
 auth: auth,
 resource: {
 properties: {
 title: 'Title of your new spreadsheet'
 }
 }
}, (err, response) =&gt; {
 if (err) {
 console.log(`The API returned an error: ${err}`);
 return;
 }

 console.log('Created a new spreadsheet:')
 console.log(response);
});
</code></pre>

blocks|key|2523820|text|如果您是新手，并且想要获取数据并将数据添加到谷歌电子表格中，请参阅下面的链接以获取分步指南。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2523821|https://www.twilio.com/blog/2017/03/google-spreadsheets-and-javascriptnode-js.html|2523822|我在最近的nodejs项目中进行了同样的测试|2523823|entityMap|0|LINK|mutability|MUTABLE|url^0|0|1A|0|0|2A|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@$9|U|A|V|1|W]]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|G]]]]

If you are new and want to get and add data to Google spreadsheets, please refer below link to get step-by-step guide.

<a href="https://www.twilio.com/blog/2017/03/google-spreadsheets-and-javascriptnode-js.html" rel="nofollow noreferrer">https://www.twilio.com/blog/2017/03/google-spreadsheets-and-javascriptnode-js.html</a>

I was tested same in recent nodejs project

I am trying to create new google spreadsheet using the google spreadsheet api using node.js

I have managed to get the Google OAuth 2.0 working, where I am getting the access tokens for the clients.

Now on searching the Google API docs there are example using the gData client library but nothing giving me pointers to node.js

Here are my findings for creating a new google spreadhseet

<ol>
<li>Upload a spreadsheet manually OR</li>
<li>Use a resumable upload link</li>
</ol>

There is not much information on the resumable upload link.

I can see the HTTP Post Request and Response but I do not understand how to construct the post request in node.js

EDIT--

I am reading <a href="https://developers.google.com/google-apps/documents-list/#creating_a_new_document_or_file_with_metadata_only" rel="nofollow">Google Apps Platform</a>

Google Spreadsheet Creation - Node.js

我正在尝试使用node.js的google spreadsheet api创建新的google spreadsheet我已经设法让谷歌OAuth 2.0正常工作，我正在为客户端获取访问令牌。现在搜索Google API文档，有使用gData客户端库的示例，但没有给出指向node.js的指针这是我创建一个新的google...

问谷歌电子表格创建- Node.js
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问谷歌电子表格创建- Node.jsEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问谷歌电子表格创建- Node.js
EN