Open up your spreadsheet from day 17 where you collected data from Questmate for a curation of no code resources. Make sure that at least one row of data is entered into your spreadsheet. \
\
Don't worry if you followed a slightly different use case, just make sure you have a spreadsheet with headings and at least one row of data.

Open[Baserow](https://baserow.io/?utm_source=newsletter&utm_medium=email&utm_campaign=100daysofnocode) in a new browser tab, log in to your dashboard and then click '**Create New**' within a workspace. 

Name your database and then click '**Add database**'.

Create new database
Would you like to import existing data?
Start from scratch
Import from Airtable (beta)
Name
Add database

Adjust each column in your table to reflect the columns in your spreadsheet. This is because you're going to map data that's entered into your spreadsheet and have it automatically populated in the correct corresponding column of your Baserow table.\
\
In this example, you'll add fields (columns) in Baserow for:

- No Code Book
- No Code Podcast
- No Code Tool
- No Code Blog
- Other Resources
- Email address

Set the column format to 'Single line text' for all columns. Remember, click the area highlighted below to bring up the options for editing your field.

You should end up with something that looks like this.

Delete all rows in your table (right click &gt; Delete row). It should look like this.

Navigate to [Zapier](https://zapier.com/sign-up?utm_source=100daysofai&utm_medium=referral&utm_campaign=100daysofaiday4)and log in.\
\
In the dashboard, click '**Create**'.\
\
You're now going to use a Zapier Zap to connect Google Sheets with Baserow.

You'll first create a Trigger. \
\
In this use case, our trigger (when we want our automation to start) is when a new row is populated in Google Sheets.\
\
Click the '**Trigger**' button.

1. 
Trigger
An event that starts your Zap

You'll be asked to select an event. \
\
An event is a starting point for a Trigger. \
\
In this use case, it's when a new row of information has been entered into your Google Sheet.\
\
Click the '**Choose an event**' field.

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

This is where you'll be asked to connect to your Google account. Follow the authorisation instructions until your Google account is connected. \
\
You'll know when it's connected as the account information will appear and a green tick will appear next to '**Account**'.

Google Sheets scottcolenutt22@gmail.com
more
scottcolenutt22@gmail.com • Used in 1 Zap
Change

Click "**Choose value…**" within the Worksheet field.

Select the sheet that contains your data.

Zapier

Baserow

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

Create a Google Sheets to Baserow Automation via Zapier