> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/integrations/gsuite/activities/sheets/range/write-range.md).

# Write Range

Write the data into the range of google sheet.

Write the values from the data table into the specified range of the google sheet.

{% hint style="info" %}
This activity can only be used after the [`Create GSuite Connection Activity`](/integrations/gsuite/activities/create-gsuite-connection-activity.md).
{% endhint %}

### Input

* **Credential**: [`Object Variable`](/getting-started/rpa-studio/variables.md#object)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  A variable name that references the user credential to access the resources.
* **SpreadSheet Id**: [`String Argument`](/getting-started/rpa-studio/arguments.md)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  The Id of the spreadsheet in which the data is to be written.
* **Sheet Name**: [`String Argument`](/getting-started/rpa-studio/arguments.md)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  The name of the sheet in which the data is to be written.
* **Range**: [`String Argument`](/getting-started/rpa-studio/arguments.md)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  The range of the sheet to write.
* **Include Headers**:
  * `True` - column headers from the specified data table will be written.
  * `False` - column headers from the specified data table will not be written.
* **Data Table**: [`DataTable Variable`](/getting-started/rpa-studio/variables.md#datatable)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage%20\(26\).png?alt=media)\
  The data table to be written.