{"id":31159,"date":"2024-11-02T16:36:06","date_gmt":"2024-11-02T07:36:06","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=31159"},"modified":"2024-11-22T17:02:09","modified_gmt":"2024-11-22T08:02:09","slug":"google_sheets_viewer","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/google_sheets\/google_sheets_viewer\/","title":{"rendered":"Google Sheets \/ Viewer"},"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 \/ Viewer<\/p>\n\n\n\n

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

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

Show the data of the Spreadsheet in a table.<\/p>\n\n\n\n

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

<\/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><\/p>\n\n\n\n

Specify the sheet name.<\/p>\n\n\n\n

Target table position or range (Optional)<\/strong><\/p>\n\n\n\n

Specify the location or range of the table to be edited.<\/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<\/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

Target table range<\/strong><\/p>\n\n\n\n

The target table range is displayed.<\/p>\n\n\n\n

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

The number of data rows in the target table range is displayed.<\/p>\n\n\n\n

Data row to start editing<\/strong><\/strong><\/p>\n\n\n\n

Specify the starting row of the data range to be edited.<\/p>\n\n\n\n

*The specified \"Data starting row\" will be the first row.<\/font><\/small><\/span><\/p>\n\n\n\n

*If a negative value is specified, it indicates the number of rows from the last line of the existing data rows. (e.g., if \"-2\" is specified, the second row from the last row is the starting line to be edited.<\/small><\/span><\/p>\n\n\n\n

Number of data rows to editing<\/strong><\/p>\n\n\n\n

Specify the number of rows to be edited from the number of rows specified in \"Data Rows to Start Editing.<\/p>\n\n\n\n

*If you specify a range that exceeds the range in which data exists, rows with no data are excluded from the data range to be edited.\n<\/small><\/span><\/p>\n\n\n\n

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

If you want to limit the column to display, specify the column name. Columns are displayed in the order in which the names are specified, from left column to right. 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.
* If not specified, all columns are displayed.<\/small><\/span><\/p>\n\n\n\n

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

Specify the display format of numbers and formulas from \"formatted value\" or \"raw value\". <\/p>\n\n\n\n

Formatted value: Values are parsed and displayed as they appear in the spreadsheet UI. Formulas starting with '=' are displayed as their evaluated results.
Raw value: Values are displayed exactly as entered by the user. Even values starting with '=' are displayed as they are.<\/p>\n\n\n\n

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

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

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

Specify the time format.<\/p>\n<\/div>\n<\/div>\n\n\n\n

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

Result Screen<\/h3>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n


Display the data in the file as a table.<\/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 \/ Viewer App overview Show the data of the Spreadsheet in a table. Extended Feature URL cbot-extension:\/\/cloud-bot:google-sheets:view: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 the URL […]<\/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=31065","footnotes":""},"categories":[127],"tags":[],"class_list":["post-31159","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\/31159","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=31159"}],"version-history":[{"count":3,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/31159\/revisions"}],"predecessor-version":[{"id":31417,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/31159\/revisions\/31417"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=31159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=31159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=31159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}