{"id":31135,"date":"2024-11-02T15:35:50","date_gmt":"2024-11-02T06:35:50","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=31135"},"modified":"2025-08-01T16:58:15","modified_gmt":"2025-08-01T07:58:15","slug":"google_sheets_create","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/google_sheets\/google_sheets_create\/","title":{"rendered":"Google Sheets \/ Create new"},"content":{"rendered":"\n

<\/i>   Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extention<\/a>> Google Sheets<\/a> > Google Sheets \/ Create new<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

App overview<\/h2>\n\n\n\n

Create a Google Sheets.<\/p>\n\n\n\n

Due to a policy change implemented by Google, new files can now only be created in Google Workspace Shared Drives.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:google-sheets:create:1<\/td><\/tr>
Provider<\/td>Cloud BOT official<\/span><\/td><\/tr>
External communication<\/td>Yes
*This application communicates with <\/a>Google Cloud<\/a>'s API.<\/td><\/tr>
Version<\/td>1<\/td><\/tr>
Transaction<\/td>Use a transaction for each execution.
2 transactions per execution<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Preconfiguration<\/h2>\n\n\n\n

Google Cloud Settings<\/h3>\n\n\n\n

When using the Google Sheets extension, it is necessary to configure Google Cloud beforehand.
Please refer to the detailed instructions here<\/a> and complete the setup.<\/p>\n\n\n\n

Screen description<\/h2>\n\n\n\n

Input screen<\/h3>\n\n\n\n

Step1<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Authentication method<\/strong><\/p>\n\n\n\n

Select the authentication method.<\/p>\n\n\n\n

Service Account: Authenticate using a Google Cloud service account.<\/p>\n\n\n\n

Authentication type<\/strong><\/p>\n\n\n\n

Specify the authentication type.<\/p>\n\n\n\n

Reference the authentication info from a file: Authenticate using a JSON file.
Enter the authentication info in JSON format: Authenticate by entering credentials in JSON format.<\/p>\n\n\n\n

* For authentication information, please refer to this<\/a>.<\/small><\/p>\n\n\n\n

Authentication file<\/strong><\/p>\n\n\n\n

This is displayed when you select 'Reference the authentication info from a file' as the authentication type.
Specify the JSON file.<\/p>\n\n\n\n

Authentication text (JSON format)<\/strong><\/p>\n\n\n\n

This is displayed when you select 'Enter the authentication info in JSON format' as the authentication type.
Enter the JSON text.<\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n

Step2<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Table starting position<\/strong><\/p>\n\n\n\n

Specify the table starting row to display.<\/p>\n\n\n\n

Header row<\/strong><\/p>\n\n\n\n

Specify the header row.
Refer to this page<\/a> about a header row.<\/p>\n\n\n\n

* Leave blank if the header row is not necessary.<\/small><\/span><\/p>\n\n\n\n

Data starting row<\/strong><\/p>\n\n\n\n

Specify the row to start writing. 
Refer to this page<\/a> about a data starting row.<\/p>\n\n\n\n

Number of columns<\/strong><\/p>\n\n\n\n

Specify the number of columns in the file to create.<\/p>\n\n\n\n

Number of rows<\/strong><\/p>\n\n\n\n

Specify the number of rows in the file to create.<\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n

Step3<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Column name<\/strong><\/p>\n\n\n\n

Enter the column name.<\/p>\n\n\n\n

You can increase or decrease columns by pressing the Add \/ Delete buttons.
Please refer to this<\/a> for the column names.<\/p>\n\n\n\n

[Note]
\nIf the header row is left blank in Step 2, Alphabets are assigned to each column name and you cannot enter these column names in Step 3.<\/small><\/span><\/p>\n<\/div>\n<\/div>\n\n\n\n

Step4<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Data<\/strong><\/p>\n\n\n\n

Input data to add. You can increase or decrease data rows by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n

* [Link elements and rows] function is useful to paste group data.\n<\/small><\/span><\/p>\n\n\n\n

Input format<\/strong><\/p>\n\n\n\n

Specify the input format.<\/p>\n\n\n\n

Enter as is: Values will be entered exactly as the user inputs them. Values starting with '=' will not be evaluated as formulas.
Enter as a formula: Values will be parsed in the same way as if entered through the spreadsheet's UI. If you input a formula starting with '=', it will be evaluated as a formula.<\/p>\n\n\n\n

Destination folder URL<\/strong><\/p>\n\n\n\n

Enter the URL of the destination folder.
For more information about the destination folder, please refer to this<\/a>.<\/p>\n\n\n\n

File name<\/strong><\/p>\n\n\n\n

Enter any file name.<\/p>\n\n\n\n

Sheet name<\/strong><\/p>\n\n\n\n

Enter any sheet name.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Result Screen<\/h3>\n\n\n\n

An Spreadsheet file is created<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

The results will be displayed.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Home > User guide > BOT > How to use the BOT editor > Extention> Google Sheets > Google Sheets \/ Create new App overview Create a Google Sheets. Due to a policy change implemented by Google, new files can now only be created in Google Workspace Shared Drives. Extended Feature URL cbot-extension:\/\/cloud-bot:google-sheets:create:1 Provider Cloud BOT official External communication Yes*This application communicates with Google Cloud's API. Version 1 Transaction Use a transaction for each execution.2 transactions per execution Preconfiguration Google Cloud Settings When using the Google Sheets extension, it is necessary to configure Google Cloud beforehand.Please refer to the detailed instructions here and complete the setup. Screen description Input screen Step1 Authentication method Select the authentication method. Service Account: Authenticate using a Google Cloud service account. Authentication type Specify the authentication type. Reference the authentication info from a file: Authenticate using a JSON file.Enter the authentication info in JSON format: Authenticate by entering credentials in JSON format. * For authentication information, please refer to this. Authentication file This is displayed when you select 'Reference the authentication info from a file' as the authentication type.Specify the JSON file. Authentication text (JSON format) This is displayed when you select 'Enter the authentication […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_locale":"en_US","_original_post":"https:\/\/docs.c-bot.pro\/?p=31023","footnotes":""},"categories":[127],"tags":[],"class_list":["post-31135","post","type-post","status-publish","format-standard","hentry","category-google_sheets","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/31135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/comments?post=31135"}],"version-history":[{"count":7,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/31135\/revisions"}],"predecessor-version":[{"id":33220,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/31135\/revisions\/33220"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=31135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=31135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=31135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}