---
# System prepended metadata

title: Zapier Challenge

---

# Zapier Challenge

Zapier is a SaaS application which allows its users to connect apps to eachother. We use Zapier at ShareSpace to make our employees lives easier by automating certain tasks without engaging the development team.

The aim of this challenge, is to automate a completely pointless process between different Google Apps.


**You will need**
* A free Google account with access to Google Sheets and Google Calendar
* A free Zapier account (www.zapier.com) - you can register using your Google Account

**The task**

When a new row is added to a Google Sheet, create an event in a Google Calendar with data from the row.

**Task steps**

First, create a Google Sheet with the following columns: 
```
Name | Surname | Description | Start | End
```
Then, create a Zap in Zapier which creates the following process:

When a new row is added to your Google Sheet, create a new event in your Google Calendar which uses data from your new row:

    event summary = Name + Surname
    event description = Description
    event start date & time = Start
    event end date & time = End

Once your Zap is created, create a new row in your Google Sheet with the following data:
```
Jan | Kowalski | Recruitment Meeting | 10/06/2021 10:00 | 10/06/2021 12:00
```
Check if a new calendar event has automatically appeared in your calendar.

**In order to complete the task, please supply the following screenshots:**
1. A screenshot of your Google Sheet
2. Multiple screenshots of each step of your Zap expanded
3. A screenshot of the event in your Google Calendar (click on it so the description is visible)

**Good Luck!**


