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.

Now you're going to test your Trigger. \
\
This is like asking Zapier to confirm that the Trigger is operating as expected, before you continue with the rest of your Zap. \
\
In this example, it's going to look for at least one row of information in your Google Sheet.\
\
Click "**Test trigger**".

The information that's displayed should feature the last row of information from your sheet.\
\
Don't worry right now if you see '**Content Hash**' listed as an item, this is just a method of encryption that's captured within your Zap.\
\
Click "**Continue with selected record**" if everything looks correct.

Click the '**Action**' button in your Zap.\
\
You're now going to show Zapier where you want it to send the information.

Select '**Create row**'. This is because you want Baserow to populate with a new row of information when your Google Sheet is populated with a new row of information.

You'll now be requested to connect Zapier with Baserow. \
\
You'll connect Zapier to Baserow via something called an API (application programming interface). You can think of this as a unique contract between Zapier and Baserow that confirms they'll privately share data with each other.

Allow Zapier to access your Baserow Account?
Baserow API token 

Please enter your Baserow API token. Can be found by clicking on your account in the top left corner -> Settings -> API tokens.

Baserow API URL 

Please enter your Baserow API URL. If you are using baserow.io, you can leave the default one.

https://api.baserow.io
Yes, Continue to Baserow
Cancel

Head back to Baserow and click the menu from the top-left hand corner.

Name your token '**Zapier**' and select your **Workspace**.

Click the three little dots next to the name of the token you just created.

Copy this Token to your clipboard using this button.

Head back to Zapier and **paste your Token in the 'Baserow API token' field**. \
\
Leave the 'Baserow API URL' as is. \
\
Click '**Yes, Continue to Baserow**'.

If everything has connected correctly, you'll see your Baserow API detailed under the 'Account' section in Zapier, with a green tick next to 'Account'.\
\
Click '**Continue**'.

You'll be asked to enter the Table ID of your Baserow table.

Head back to Baserow, click the settings menu from the top-left hand corner and click 'Database tokens' from the 'Settings' menu.\
\
Now click the arrow next to 'show databases'. This is where you'll find your Table ID.

Copy your table ID (just the numbers) to your clipboard.

Close the 'Database tokens' screen in Baserow.

Head back to Zapier and paste in your Table ID into the Table ID field.\
\
You're now making sure that the exact table in Baserow that you want data to be sent to is selected.

Wait a few moments and you should see this section populate with the headings from your Baserow table. \
\
You're now going to map each of your Baserow fields (columns) with the corresponding columns in Google Sheets. This'll ensure that when the data is sent from Zapier to Baserow, it ends up in the correct place.\
\
Click the '**Enter text or insert data...**' field on each option and map it to the corresponding column in Google Sheets.

Click '**Test Step**'.\
\
Now Zapier is testing the Zap by sending the last row of data from your Google Sheet to your Baserow table. \
\
You'll know when it's finished as you'll see the confirmation message saying '**A Row was sent...**' 

Head back Baserow and you should see your data populated in the table!\
\
Note: Sometimes it can take a few minutes before the data populates in Baserow as the platforms 'speak' to eachother. Don't panic if you don't see your data immediately. Give it up to 10 minutes and refresh your page in Baserow if you don't see anything. 

Head back to Zapier and give your Zap a name.

BAM you've created an automation between Google Sheets and Baserow.\
\
Whenever a row of data is updated in your Google Sheet, it'll be sent to Baserow!\
\
Now, do you want an extra credit? 😎\
\
Watch your entire automated workflow unfold by heading back to yesterday's lesson and submit some demo information in your Questmate form.\
\
Watch as it's collected in Google Sheets.\
\
...then watch again as it populates in Baserow!

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