Start today's lesson by opening [Google Sheets](https://docs.google.com/spreadsheets/create)

Create a new spreadsheet called '**daily sales**' populate it with something that looks something like what's below.\
\
In this example, you're going to take on the fictional role of an employee that's often asked by their manager to provide cumulative monthly sales figures. To keep it simple, you're just going to focus on total monthly sales.\
\
In this company, there are lots of spreadsheets and one sheet within a spreadsheet is automatically updated with the cumulative total sales from the month.\
\
Every time you're asked by your manager to provide the up-to-date figure, you have to find the spreadsheet, find the sheet and find this number. It's tedious and boring, but it's inevitable that they're going to ask, as they do this almost every day.

Open [Zapier](https://zapier.com/sign-up?utm_source=100daysofnocode&utm_medium=referral&utm_campaign=100daysofnocodeday19). \
\
Click '**Create**' and then '**Zaps**'.

You're first going to **add your Trigger.** \
\
In this example, your automation is triggered by when the 'Total Sales' figure automatically updates each day.

1. 
Trigger
An event that starts your Zap

Select '**New or Updated Spreadsheet Row**'.

Triggered when a new row is added or modified in a spreadsheet.

You're now in the '**Account**' section where you'll either be prompted to authorise access to your Google account or, if you've connected Google Sheets previously, you'll see your account listed here.\
\
Check everything is as expected and click '**Continue**'.

Search and select your '**daily sales**' sheet.

1NtgMLYQ8j3aPBr7MCftYkNO_5X1s6PD8XaXcffcyIbY

Click the "**Choose value…**" field under '**Worksheet**'.

Select the sheet containing your sales data.

Select the row that contains your cumulative monthly sales figure.

Click "**Continue with selected record**".

You're now going to configure the action. In this example, you're going to automate an email that's sent to you every time the total monthly sales figure is updated.\
\
Search and select '**Gmail**'.\
\
Note: You can use a different email provider if you like, the steps will be similar.

You'll be prompted to connect your email provider on this screen.\
\
Connect your account and click '**Continue**'.

Click the 'To' field and enter the email address of the person you'd like to send the email to.\
\
In this example, it'd be a little passive aggressive if you just started sending your manager these daily figures, so you'll start by just sending them to yourself in an email. 

Click the "**Choose value…**" field in the '**From**' settings.

Enter the subject '**Monthly Sales Total**'.

Click in the body field and type 'Monthly sales total:'

Select 'T**otal Sales This Month**' from the '**Insert Data**' menu that appears within the '**body**' field.

Check that the test information looks accurate and click "**Test step**".

Head over to your email client and you should have received an email containing the monthly sales figure!

Head back to Zapier, give your Zap a name (top-left corner) and click '**Publish**' if everything is working as expected.

Head back to your spreadsheet and update the monthly sales figure.

If everything is working as expected, you should now have a new email with the updated sales figure. 

You're now flying with automations using Zapier!\
\
You're happy and your manager can't believe the speed of your responses. You always know the numbers!\
\
What could make this workflow even more efficient? Setting up an email rule in your email client to collect all these monthly sales emails. 🤓

Automate a Boring Task with Zapier