{"id":32010,"date":"2025-01-14T14:35:11","date_gmt":"2025-01-14T05:35:11","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=32010"},"modified":"2025-01-23T09:30:55","modified_gmt":"2025-01-23T00:30:55","slug":"google_sheets_add_data","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/google_sheets\/google_sheets_add_data\/","title":{"rendered":"Google Sheets \/ Add data row"},"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 \/ Add data row<\/p>\n\n\n\n

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

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

Add a new data row to the Google Sheets.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:google-sheets:add-data: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\n\n\n

Spreadsheet URL<\/strong><\/p>\n\n\n\n

Specify the URL of the spreadsheet to be edited.<\/p>\n<\/div>\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

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

Select the sheet to add a data row to.<\/p>\n\n\n\n

Targeted table position or range (optional)<\/strong><\/strong><\/p>\n\n\n\n

This option allows you to specify a range of cells to target. If not specified, the target is the entire sheet selected as [Sheet Name]<\/strong>. Refer to this page<\/a> about a targeted table position or range.<\/p>\n\n\n\n

*Notes on the input range for the target table can be found here<\/a>.<\/small><\/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. An alphabet is assigned automatically for a column name.<\/small><\/span><\/p>\n\n\n\n

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

Specify a number of rows added to the file.<\/p>\n\n\n\n

Specify column order (Optional)<\/strong><\/p>\n\n\n\n

If you want to limit rows to input, specify the column name. The column with no data become blank. You can increase or decrease columns to be displayed by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n

* If multiple columns have the same name, they are displayed in order from left column to right.
\n* If not specified, all columns are displayed.<\/small><\/span><\/p>\n<\/div>\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

The target table range<\/strong><\/p>\n\n\n\n

The target table range is displayed.<\/p>\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.<\/small><\/span><\/p>\n\n\n\n

Input format<\/strong><\/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<\/div>\n<\/div>\n\n\n\n

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

Edited data<\/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\n\n\n

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

The number of succeeded added data rows<\/strong><\/p>\n\n\n\n

The number of successfully added data rows is displayed.<\/p>\n\n\n\n

The number of failed added data rows<\/strong><\/p>\n\n\n\n

The number of data rows which were failed to add is displayed. Refer to this page<\/a> for example of failing to add.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Notes on the Target Table<\/h3>\n\n\n\n

Depending on the input status of the Google Sheets, data rows may be added in unintended locations.<\/p>\n\n\n\n

When adding data rows, the existing data in the spreadsheet is searched to recognize the 'table' within the specified input range.
A 'table' refers to a collection of adjacent cells containing values.
Data is added based on the first column of the lowest table within the specified input range.<\/p>\n\n\n\n

Let's take the following as an example.
This sheet has two tables, A1:C2 and B4:D6.<\/p>\n\n\n\n

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

In the following case, row addition starts from B7.<\/strong><\/p>\n\n\n\n

    \n
  • If the target table position or range sheet is not specified (since Table :2 is the last table).<\/li>\n\n\n\n
  • If B4 or C5:D5 is specified (as both are within Table:2).<\/li>\n\n\n\n
  • If B2:D4 is specified (since the last table within the range is Table:2).<\/li>\n\n\n\n
  • If A3:G10 is specified (since the last table within the range is Table:2).<\/li>\n<\/ul>\n\n\n\n
    <\/div>\n\n\n\n

    In the following cases, row addition starts correctly.<\/strong><\/p>\n\n\n\n

      \n
    • If A1 is specified, writing starts from A3 (since it is within Table:1).<\/li>\n\n\n\n
    • If E4 is specified, writing starts from E4 (since it is not within any table).<\/li>\n\n\n\n
    • If A4 is specified, writing starts from A4 (since it is not within any table).<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        Home > User guide > BOT > How to use the BOT editor > Extention> Google Sheets > Google Sheets \/ Add data row App overview Add a new data row to the Google Sheets. Extended Feature URL cbot-extension:\/\/cloud-bot:google-sheets:add-data: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 info in JSON format' as the authentication type.Enter the JSON text. Spreadsheet URL Specify […]<\/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=31972","footnotes":""},"categories":[127],"tags":[],"class_list":["post-32010","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\/32010","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=32010"}],"version-history":[{"count":3,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/32010\/revisions"}],"predecessor-version":[{"id":32037,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/32010\/revisions\/32037"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=32010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=32010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=32010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}