Create a Google Sheets to Baserow Automation via Zapier | Scribe

    Create a Google Sheets to Baserow Automation via Zapier

    • Scott Colenutt |
    • 53 steps |
    • 5 minutes
    1

    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.

    2

    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.

    3

    Click "**Database**".

    4

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

    5

    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.

    6

    You should end up with something that looks like this.

    7

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

    8

    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.

    9

    Click '**Zaps**'.

    10

    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.

    11

    Search and select '**Google Sheets**'.

    12

    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.

    13

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

    14

    Click "**Continue**".

    15

    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**'.

    16

    Click "**Continue**".

    17

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

    18

    Find and select your Google Sheet.

    19

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

    20

    Select the sheet that contains your data.