> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://helpdesk.closum.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to create an automation with Google Sheets

Automating processes in Google Sheets can save time, reduce errors and optimise data management. 

With the Google Sheets integration in the Marketplace, you can turn spreadsheets into powerful tools, automating tasks such as sending emails, generating reports and updating data in real time.

In this guide, we'll explore how to create efficient automations in Google Sheets using extensions available in the Marketplace, easing your workflow and increasing productivity. 🚀
---

To get started, go to our **Marketplace **and click on Settings » Apps.


Within "Apps", click on "**Connect App**".

![](https://storage.crisp.chat/users/helpdesk/website/-/1/3/2/3/13239d1250467e00/image_15woyxk.png)

And select the "**Google Sheets**" application![](https://storage.crisp.chat/users/helpdesk/website/-/1/3/2/3/13239d1250467e00/1fb07c93-d155-48d9-b433-afa44b_wdcxp9.png =800x450)
And then** grant access to Google Sheets**.

![](https://storage.crisp.chat/users/helpdesk/website/-/1/3/2/3/13239d1250467e00/image_3gba1u.png)

You must select the Google account you want to use and allow access

Once set up, you can start creating the automation you want


![](https://storage.crisp.chat/users/helpdesk/website/-/1/3/2/3/13239d1250467e00/image_fiwquf.png)