> For the complete documentation index, see [llms.txt](https://software-help-docs.gitbook.io/knowledge-base/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://software-help-docs.gitbook.io/knowledge-base/software-guide/workflows/premium-triggers-and-actions/google-sheets-premium-action/create-spreadsheet-row.md).

# Create Spreadsheet Row

Our LC Premium Actions enables you to send data to a Google Sheets document directly, without requiring any third-party integrations. All you need to do is integrate your Google account with our system and select the desired sheet from your Google Drive. From there, you can easily send data to the sheet using our intuitive user interface.

This eliminates the need for complex integration processes and provides a streamlined solution for sending data to Google Sheets. With our out-of-the-box functionality, you can quickly and easily automate your data workflows and simplify your data management processes.

***

### Choose a Google account:

All your integrated Google accounts in your subaccount, will be displayed in the dropdown menu for you to choose from.

![](https://t8631005.p.clickup-attachments.com/t8631005/a486d223-1717-4c60-a246-a0fe4551f445/2%20account.png)

***

### Select a Drive:

Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account that contains the target Google Sheets document that you want to send data to.

![](https://t8631005.p.clickup-attachments.com/t8631005/a2b9791d-5e28-452b-8a59-5b67e402fd36/3%20drive.png)

###

***

### Select a Spreadsheet:

Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated to the selected Google Drive will be displayed for you to choose from.

This allows you to select the specific Google Spreadsheet document that you want to send data to.

![](https://t8631005.p.clickup-attachments.com/t8631005/dede2b3d-39cc-48f8-9889-5c0b426c6174/4%20spreadsheet.png)

### Select a Worksheet:

Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from.

This allows you to select the specific Worksheet that you want to send data to.

![](https://t8631005.p.clickup-attachments.com/t8631005/57ba3ab1-0734-4690-9db2-c6698ed0b1b2/5%20worksheet.png)

***

### Selecting Starting Column and End Column in the worksheet

When sending data to a Google Sheets document using our workflow system, the first row of the sheet is automatically considered as the header row, and each column is labeled based on the header values in that row.

If you need to update the headers in the sheet, you can simply click the “Refresh Headers” button to fetch the latest header values from the sheet. This ensures that your data is properly mapped to the correct columns in the sheet, and that your workflow is up-to-date with the latest sheet configurations.

By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows.

![](https://t8631005.p.clickup-attachments.com/t8631005/9f4f5056-5830-499d-a842-8c143631dc3a/image.png)

***

### Insert values to create a new row in the worksheet:

You can insert value and create a new row in your Google Sheets document.

![](https://t8631005.p.clickup-attachments.com/t8631005/696d196b-aafe-408a-a0de-188693c01375/8%20data.png)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://software-help-docs.gitbook.io/knowledge-base/software-guide/workflows/premium-triggers-and-actions/google-sheets-premium-action/create-spreadsheet-row.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.