# 🧠 Getting Started with Google Sheets

**URL:** <https://community.make.com/t/getting-started-with-google-sheets/4294>\
**Category:** Knowledge Hub\
**Tags:** best-practices\
**Created:** [September 20, 2022, 10:35am UTC](https://community.make.com/t/getting-started-with-google-sheets/4294 "2022-09-20T10:35:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\
**Post date:** [September 20, 2022, 10:35am UTC](https://community.make.com/t/getting-started-with-google-sheets/4294/1 "2022-09-20T10:35:15Z")

</div>

# Hey Makers 👋
  

> Today, I’d like to share a nifty tutorial where @Matous_Vrba from our Growth team tells you all about building your first scenarios with Google Sheets.

> The video covers step-by-step instructions on creating two scenarios.  
> Read on to see what the scenarios are or skip to the end of the post to watch the tutorial.

  

## 1️⃣ Grabbing data from a Google Sheet and sending it to Slack

  

_ **An example story behind the scenario** _

There’s a spreadsheet with a list of new employees joining the company that is constantly being updated. Whenever a new hire is added to the sheet, a Slack message is sent to the person who manages the onboarding of new employees so that they can get everything ready.

_ **What the scenario looks like** _

 ![scenario 1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/296b12d5b58411ece2913703af55e0a2f8b223c4.png)

  

_ **In the tutorial, you’ll learn how to** _

- Create Google Sheets & Slack connections
- Set up the Google Sheets module that triggers the automation
- Choose from where to start processing your data
- Set up the Slack module to send the automated message
- Test the automation and check if everything works
- Schedule your workflow to run as often as you like
- Activate and save your scenario  
  
  
  

## 2️⃣ Storing data from your Gmail inbox in a Google Sheet

  

_ **An example story behind the scenario** _

Your accounting team needs to create an expense report. All relevant expense details get extracted from an email inbox and stored in a dedicated spreadsheet. As a result, you get a sheet with an overview of the expenses themselves as well as their statuses.  
  
  
_ **What the scenario looks like** _

 ![scenario 2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/1/1f1f36770e920ff4907ba8fc2a6741c6687e0fb6.png)

  

_ **In the tutorial, you’ll learn how to** _

- Create your Gmail connection
- Configure the Gmail module that triggers the automation
- Choose from where to start processing your data
- Set up the Google Sheets module that adds data into your spreadsheet
- Test the automation and check if everything works
- Schedule your workflow to run as often as you like
- Activate and save your scenario

  
  

## 📽 Watch the Full Tutorial

  

[https://www.youtube.com/watch?v=DBrw5ic1DSk&ab\_channel=Make(formerlyIntegromat)](https://www.youtube.com/watch?v=DBrw5ic1DSk&ab_channel=Make%28formerlyIntegromat%29)