Create a sample GetBusy Zap with Google Sheets

If you haven't already, please read Integrate GetBusy with other apps using Zapier before you continue.

Here's a simple integration to set up if you'd like to get familiar with the GetBusy Zapier Integration before you start automating your real processes...

We'll create the following simple Zap:

• Trigger - When a new row is added to a simple contact list in Google Sheets.
• Action - Add a connection in GetBusy (if it doesn't already exist) and create a Note with them.

Create a contact list

• Using a Google Account, open Google Sheets.
• Create a Google Sheet called 'Contact List' and add column headers for 'First name', 'Last name' and 'Email address'.
• Add a new row for a test contact. To test it properly, you'll need to add an email address that exists and that you can access / control.

Now that you've added a new row with the details required to create a GetBusy Connection, you can create your Zap.

Create a zap

• Sign in to your Zapier Account and click the 'Make a Zap!' button.
• Name your zap 'Create GetBusy Welcome Notes for New Google Sheets Contacts'.

Configure a trigger

• Choose 'Google Sheets' as the Trigger App.
• Choose 'New Spreadsheet Row' as the trigger and click 'Save + Continue'.
• Follow the Zapier prompts to sign in to Google and 'Test' the account connection before clicking 'Save + Continue'. Signing in may happen automatically if you are already signed in to Google.
• Choose the 'Contact List' Spreadsheet followed by the 'Sheet' Worksheet (assuming you have not changed the default name of the worksheet) then click 'Continue'.
• Zapier will then take a second or two to get some row data from the Contact List spreadsheet.
• Assuming everything has gone to plan, a single sample row will appear in Zapier and be labelled as 'Spreadsheet Row A' (or similar). Expand the sample to check it contains the details of your contact.

Configure an action

• 'Add a step' to your zap and click 'Action/Search'.
• Search for 'GetBusy' in the list of available apps and select it.
• Select 'Create a New Note' as the GetBusy Action
• Follow the Zapier prompts to sign in to GetBusy and 'Test' the account connection before clicking 'Save + Continue'. Signing in may happen automatically if you are already signed in to GetBusy.
• In the 'Set up GetBusy Note' screen, perform the following steps:
  • Connection name: Use the 'Insert a field' button to add the {First name} and {Last name} placeholders from the sample row. Insert your text cursor in between the two placeholders and add a space with your keyboard.
  • Connection email: Use the 'Insert a field' button to add the {Email address} placeholder.
  • Title: Type a title of your choosing e.g. 'Welcome to ABC Services'
  • Comment Text: Type a comment of your choosing e.g. 'Hi, Good to have you aboard. We use GetBusy to provide you with great service by making it easier to see, and stay on top of what's going on and what needs to be done...'
• Click 'Continue'.

Tip: You can use the 'Insert a field' button to customize your Title and Comment.

Test your zap

• Click 'Send Test to GetBusy'.

The test will use the data in the sample row to add a Connection in GetBusy (if it doesn't already exist) and create a GetBusy Note using the title and comment that you have specified.

Turn on your zap

Once your test has been successful:

• Click the 'Finish' button.
• Turn your zap on when asked if you are 'Ready to turn on your Zap?'.

From now on, any new row added to the Contact List spreadsheet in Google Sheets will create a new connection in GetBusy using the value in the First name, Last name and Email address columns.  A Note will be created and sent to the connection using the title and comment you have specified in the zap.

Need help?

We're happy to help if your struggling...please contact us using the Feedback option in the GetBusy Main Menu to let us know what's up and we'll do our best to get you pointed in the right direction.