1. Login to Zapier.
2. Select “App Connections” from the left-hand menu.
3. Click “Create connection”.
   
4. Search for “bublup” and select the latest version.
5. You will be prompted to login with your Bublup email and password.

Once successfully connected, you will see Bublup under your Connections list with a “Connected” status. Currently in Zapier, you have the ability to create or update Bublup items (notes and links), add Community members, and create Org Members,

Add or update note and link items within a Bublup space inside your Organization or Community.

Step 1: Prepare Your Google Sheet

Before you jump into Zapier, create a new Google Sheet. The first row should contain the headers for the data you want to collect. For items importing, your headers might be:

• Title
• Description
• URL
• Address
• City
• State
• Country
• External ID

Note: If a URL is included, the item will be imported as a link; otherwise it will be imported as a note. For note items, the only required field is a description. If location fields are included, the item will be saved with location information attached.

Pro Tip: Create clear and specific headers. Don’t change them after you set up your Zap, as Zapier uses these headers to know where to put the data. Changing a header will break your Zap!

Step 2: Create a New Zap and Set Up the Trigger

1. Log into your Zapier account and click the “Create Zap” button.
2. Choose the Trigger App: Search for and select “Google Sheets.”
3. Select the Trigger Event: choose “New or Updated Spreadsheet Row.”
   
   (This tells Zapier to start the workflow whenever a row is added or updated in the sheet.)
4. Connect Your Account: Zapier will prompt you to connect your Google account if you haven’t already. Follow the on-screen instructions to grant access.
5. Select Your spreadsheet and worksheet (tab) you would like to connect.
   
   
6. Select the trigger column from the available sheet columns.
   For note items, we recommend using the “description” column. For link items, we recommend using the URL column. If your sheet has a combination of item types, go with whatever column will be non-empty in every valid row.
7. Test the Trigger: Zapier will attempt to fetch the records from the google sheet to use as sample data. Once you see the sample data pulled in successfully, you can move on to the action.

Step 3: Set Up the Bublup Action

Now you’ll tell Zapier what to do with the data from Google Sheets.

1. Choose the Action App: Search for and select “bublup”.
2. Select the Action Event: Select “Create/Update a Bublup Item.“
   
   
3. Connect Your Bublup Account by signing in. Then click “continue”.
4. Under “Enter Space Name to Find…”, enter the name of your space where you wish to upload items. Then click on “Select Space” and find the correct space (based on the name you entered).
   
5. Map Your Data Fields: Map each of the Bublup fields to their corresponding columns from your Google Sheet.
   
6. Test the Action: After mapping all your fields, click “Test & Continue.” 
7. If the test data looks correct, your final step is to click “Publish Zap“.

That’s it! Your automation is now live and will run in the background 24/7 whenever the google sheet is updated and you will receive a notification when an item is successfully imported.

Pro Tip: Updating existing items

Use the “External ID” field to assign unique IDs to an item. This will allow you to update an existing item via the Zapier integration instead of creating a new one.