How
Sign Up Free
How

Author: Pabbly Team

Posted on

How to Save New Stripe Charges Automatically to Google Sheets

How to Save New Stripe Charges Automatically to Google Sheets

Are you looking for a way to save new Stripe charges automatically to Google Sheets? If yes, here in this article we will provide a step by step guide to integrate Stripe with Google Sheets.

How to Save New Stripe Charges Automatically to Google Sheets

But before moving forward, let’s know a little bit about both the software & why there is a need to integrate Stripe with Google Sheets. As we all know, Stripe is a payment infrastructure that allows you to accept payments and manage payouts for all kinds of businesses. On the other hand, Google Sheets Online is spreadsheet software that allows users to create, update & modify spreadsheets and share the data live online, and much more.

By connecting Stripe with Google Sheets, one can automatically save every Stripe charge to Google Sheets in real-time. To help you with this we are recommending business automation software named Pabbly Connect.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect         

Pabbly Connect is one of the best automation tool that allows you to integrate unlimited apps without any coding skill. Moreover, you can also access its features such as filters, path routers, etc even in its free plan.

Here in this article, we will understand how to integrate Stripe and Google Sheets using an automation tool i.e Pabbly Connect.

How to Save New Stripe Charges Automatically to Google Sheets (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to Stripe

6. Test the Response

7. Setting Action

8. Check Response

So, let’s start the integration process.

Step 1: Sign up to Pabbly Connect

Sign Up

The process of connecting Stripe to Google Sheets starts by pressing the “Sign Up Free” button on the Pabbly Connect dashboard. Furthermore, you can either manually enter the entire details or else sign up via Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Later on, after logging into the account, simply tap on the “Access Now” button as shown in the above image.

Step 3: Workflow for Stripe & Google Sheet Integration

(a) Start with a New Workflow

Create New Workflow

Now, let’s begin the procedure of building a workflow for integration by pressing on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Additionally, now name the workflow that in our case is “Stripe to Google Sheets”. However, you can always change the workflow name according to your requirements.

Step 4: Setting Trigger for Stripe & Google Sheets Integration

After building a workflow, now choose the integration app to connect your Stripe account to Google Sheets. Pabbly Connect lets you create unlimited workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

Now, it’s time to choose the application i.e, “Stripe” from the dropdown, then choose the method i.e, “New Charge” to add payments in Google Sheets automatically.

(b) Copy the Webhook URL

Copy the Webhook URL

Later on, you have to copy the webhook URL that is appearing on the dashboard. You can either copy the link directly or else click on the “Copy” button.

Step 5: Connecting Stripe to Pabbly Connect

However, in order to save new Stripe charges automatically to Google Sheets, you gotta paste the copied Webhook URL in the software. Hence to do that, you have to log in to your Stripe account.

(a) Go to Developer Section

Go to Developer Section

Once you log into the Stripe account, just go to the “Developer” section on the left of the dashboard. Then, press on the “Webhooks” option.

(b) Click on Add Endpoint

Click on Add Endpoint

Afterward, when you click on “Webhooks”, an endpoint tab will open up, just tap on the “Add Endpoint” option in order to paste the Webhook URL.

(c) Paste the Webhook URL

Paste the Webhook URL

Once you press the “Add Endpoint” button, it will open up the window with options. All you need to do is paste the copied URL in the “Endpoint URL” section. Moreover, you have to make sure that you select charge.succeeded in the “Event to Send” column. Ultimately, just tap on “Add Endpoint” to save the setting.

(d) Click on Payment Option

Click on Payment Option

Subsequently, now go back to the “Payment” section on the left of the dashboard, after that just press the “New” button to add payment.

(e) Add Payment

Add Payment to Save New Stripe Charges Automatically to Google Sheets

As soon as you click on the “New” button, a pop-up will appear. Simply enter all the required details & press the “Create Payment” button at the bottom. But before you that, you have to click capture webhook response in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

Once you tap on the “Add Payment” option, the entry will appear on the “Pabbly Connect” dashboard. Just tap on the “Save” option.

Step 7: Setting Action for Stripe & Google Sheets Integration

Consequently, in order to make this Stripe and Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Save New Stripe Charges Automatically to Google Sheets

Next, hit the “+” icon and then select “Google Sheet” application & in the choose method option, select ” Add New Row”. Afterward, just click on the button named “Connect” in order to authorize it with Google account.

(b) Click the Connect Button

Click the Connect Button to Save New Stripe Charges Automatically to Google Sheets

After pressing the “Connected with Google Sheet” button, an authorization window will open up, so that you can log in to your Google account.

(c) Map Field Data

Map Field Data to Save New Stripe Charges Automatically to Google Sheets

All the sheets in your account will appear on the dropdown, just select the sheet that is “Sheet1”. After that, add the necessary field from drop-down like for the name, amount, and seller message. Following that, simply tap on the button named “Save & Send Test Request”.

(d) Test the Submission and Save

Test the Submission and Save to Save New Stripe Charges Automatically to Google Sheets

Consequently, once you hit the “Send Test Request”, all the entries will be sent to Google Sheets Rows. Just hit the “Save” button in order to save the entire workflow.

Step 8: Check Response in Google Sheet

Check Response in Google Sheets to Save New Stripe Charges Automatically to Google Sheets

Finally, as you can see, all the entered details have been auto-populated in the Google Sheets.

Conclusion –

Hopefully, Now you know how to save new Stripe charges automatically to Google Sheets. Moreover, it’s a one-time process, so you don’t have to worry about doing it again and again. So, just sit back and relax!! As by using Pabbly Connect one can easily avoid repetitive work that allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like To Read –

Posted on

How to Add Google Calendar Events for Bookings on YouCanBook.me

Add Google Calendar Events for Bookings on YouCanBook.Me

In this blog, we are going to proceed the step by step procedure to add Google Calendar events for bookings on YouCanBook.me automatically.

We are going to integrate YouCanBook.me with Google Calendar using Pabbly Connect to automatically add YouCanBook.me bookings as Google Calendar events. Pabbly Connect enables connecting two or more services to shares data in real-time.

Add Google Calendar Events for Bookings on YouCanBook.Me

We’ll set up a trigger on the YouCanBook.me new bookings and its respective action for creating events on Google Calendar.

Also, Pabbly Connect provides instant triggers, routers, filters and formatters to design limitless workflows. Further, it also allows you to use many advanced options like multi-step calls, integration with unlimited premium apps etc. And all this without writing a single line of code or help from a professional.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect  

In a few minutes interval, it allows you to add the freshly scheduled bookings as events on your Google Calendar. So, save your time and access all Pabbly Connect features without any restriction even in its free plan.

Now, let’s move forwards with the step by step procedure to integrate YouCanBook.me to Google Calendar and automatically add the newly added bookings as events.

How to Add Google Calendar Events for Bookings on YouCanBook.me (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create a Workflow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Trigger

7. Setting Action

8. Save the Workflow

Step 1: Sign up to Pabbly Connect

Sign Up

Visit the official website of Pabbly Connect & then hit the ‘Sign-Up Free‘ button. Next, on the registration page signup using an existing Google account or manually fill in the form to get into the system.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ Pabbly application.

Step 3: Workflow for YouCanBook.me with Google Calendar Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to add new YouCanBook.me bookings to Google Calendar as events and to do this strike the ‘Create New Workflow’ button.

(b) Name the Workflow

YouCanBook.me to Google Calendar Workflow

Now, name the workflow as per your need (for instance: YouCanBook.me to Google Calendar etc) and push the ‘Save’ button.

Step 4: Setting Trigger YouCanBook.me – Google Calendar Integration

To automatically add new YouCanBook.me bookings to Google Calendar as events whenever a booking happens, you need to set-up a trigger on ‘New Booking’ and its respective action to add an event in your Google Calendar.

(a) Select Application you want to integrate

Integrate YouCanBook.Me

When you hit the save button to create a workflow, a trigger window will open next.

You’ll need to select the ‘YouCanBook.me’ option from the ‘Choose App’ field drop-down options.

(b) Copy the Webhook URL

Copy Webhook URL

Check, the method in here to be ‘New Booking’ & copy the ‘Webhook URL’ by clicking the ‘Copy’ button on this page.

Up to this point, we are half-way done with the YouCanBook.me to Google Calendar integration’s trigger. And now, we’ll need to paste this URL on our YouCanBook.me settings to get the trigger working.

Step 5: Connecting YouCanBook.me to Pabbly Connect

To connect your YouCanBook.me account and Pabbly Connect. First, sign-in into your YouCanBook.me account.

(a) Go to Your YouCanBook.me Account

Create Booking Page

After signing in to your YouCanBook.me account, click the plus button to create a booking page.

Set the booking page status from ‘Offline’ to ‘Online’.

Lastly, hit the ‘Edit’ button to set up the booking page.

(b) Name the Booking Event

Booking Page Title

Assign a name to your booking page.

(c) Add the Required Additional Form Fields

Additional Form Fields

Now, go to the ‘Booking Form’ option present in the left verticle menu and then add some additional form fields that would be required afterwards.

(d) Go to Booking Page Notification Settings

YouCanBook.me Event

Click on the notifications option available in the left verticle menu.

Next, select the trigger ‘After new booking made’ and then push the plus ‘+’ button available there.

(e) Click on ‘Webhook’ Button

Click on Webhook

A small pop-up will open up carrying some buttons, click on the ‘Webhook’ button.

(f) Paste Webhook URL

Paste Webhook URL

Now, paste the copied Webhook URL form Pabbly Connect in the ‘URL’ field here. Also, select the HTTP method as ‘POST’.

(g) Add Code for Additional Form Fields

Add Code & Save Changes

You’ll need to add code for the additional form fields that we’ve added on Step 5 (c).

Lastly, click on the ‘Save changes’ button on this page.

Step 6: Test the Trigger Response in Pabbly Connect Dashboard

As we can see we are done setting up the trigger to send order data when a new booking is made through YouCanBook.me. So now, let’s just test the trigger by making a test booking on YouCanBook.me.

(a) Capture Webhook Response

Capture Webhook Response

To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.

(b) Go to the YouCanBook.me Account’s Live Booking Page

Live Booking Page

Open the YouCanBook.me booking page by hitting the ‘Live Booking Page’ option from the left verticle menu.

(c) Select Date & Time

Pick Date & Time

Next, click select the date and time for booking a slot.

(d) Fill in the Required Form Fields

Fill In Form Details

Feed all the required details to complete the booking and lastly hit the ‘Confirm Booking’ button.

(e) Confirm Booking

Confirm Booking

After filling in all the required form details, click on the ‘Confirm Booking’ button.

(f) Check Trigger API’s Response

Webhook Response

Check the captured trigger response in the Pabbly Connect trigger window. You can see all the data fed while YouCanBook.me booking is in the response.

Step 7: Setting Action for YouCanBook.me – Google Calendar Integration

As we can see the response that we got of the YouCanBook.me trigger contain all the booking data. But, the date/time format is a little different than the format of the Google Calendar.

So, before sending the YouCanBook.me booking data to add an event on Google Calendar properly, we need to match both the date/time format.

(a) Select Application You Want to Integrate

Integrate Date Time Converter

To match the date/time format for both the services, integrate a date/time formatted first.

Click the plus button next to your YouCanBook.me trigger window.

And in the action window that opens next, choose the ‘Date/Time Formatter’ app from the ‘Choose App’ field’s drop-down menu.

(b) Connect with Google Calendar

Connect with Google Calendar

Select the method in here as ‘Format’ and then click the ‘Connect with Date/Time Formatter’ button.

(c) Map Start Date

Map Start Date

Now, map the start date and timezone in the formatted fields with the YouCanBook.me trigger response.

To map value with a field, place your cursor in that particular field and then click the three horizontal lines or menu icon next to it. And click on the response value that you want to map.

(d) Select the Google Calendar Date/Time Format

Google Calendar Date Time Format

Pick the ‘YYYY-MM-DDTHH:mm:ssZ’ format from the format field’s drop-down.

Lastly, hit the ‘Save & Send Test Request’ button.

(e) Check the API Response

Start Date Response

You can see the formatted startDate and time in the API response.

Similarly, you’ll need to repeat this step (i.e, Step 7 (a) to (e)) for the formatting the ‘endDate’ as well.

(f) Select Application You Want to Integrate

Integrate Google Calendar

To start adding new YouCanBook.me bookings as events on Google Calendar, click the plus button next to your Date/Time Formatter API window.

Then select the ‘Google Calendar’ app to integrate from the ‘Choose App’ field’s drop-down menu.

(b) Connect with Google Calendar

Connect with Google Calendar

Next, select the method in here to be ‘Create an Event’ and then click ‘Connect with Google Calendar’ button.

(c) Authorize Google Account

Authorize Google Account

A window will slide in from the right, click on the ‘Connect’ button in this window.

(d) Select the Google Calendar & Map Values

Select Calendar and Map All Other Entries

Select the calendar account from the ‘Calendar’ field’s drop-down.

Also, map all the other fields with the trigger response values.

(e) Map the Guest

Map Guest Email

To map the Guest email first, place the code – {“email”: “”} in the field and map the guest email from the response in the black quotes.

(f) Place Recurrence Rule Save & Send Test Request

Event Recurrence Rule

Copy the rule from the instruction given below the ‘Event Recurrence Rule’ and paste it in the field text area.

Lastly, click the ‘Save & Send Test Request’ button.

(g) Save & Send Test Request

Save & Send Test Request

After mapping all the necessary fields, click on the ‘Save & Send Test Request’ button.

(h) Check the Action API’s Response

API Response

You can check the response of your API in the action window.

(i) Check the Event Entry in Google Calendar

Google Calendar Response

Also, you can check the entry of a new done in your connected Google Calendar account.

Step 8: Save the Workflow

(a) Save the Action API’s Response

Save Action API

Save the action API’s response by hitting the ‘Save’ button at the bottom of the action API’s response.

(b) Save the Workflow

Save Workflow

As we can see the Webhook is working perfectly. So, simply save the webhook by clicking the save button in the trigger window.

Wind-Up

Well, this is all about ‘How to add Google Calendar events for bookings on YouCanBook.me’. Consequently, after completing the step by step procedure, you will end up adding all the new YouCanBook.me bookings as events on Google Calendar. Most importantly, the procedure is very easy to implement and you don’t need any coding knowledge to follow the steps.

Try Pabbly Connect for FREE.

For any further questions, do comment below. We’ll get back to you ASAP.

You May Also Like to Read:

Posted on

How to Create GetResponse Contacts from New Google Sheets Rows

How to Create GetResponse Contacts from New Google Sheets Rows

Do you spend so much time finding a way to create GetResponse contacts from new Google Sheets rows in real-time?

How to Create GetResponse Contacts from New Google Sheets Rows

If that’s a case then no need to worry as we are suggesting a technique to integrate Google Sheets and GetResponse using Pabbly Connect.

But we know the question must be popping into your head like why there is a need of integrating Google Sheet and GetResponse? And the answer is by connecting both software you can transfer data automatically between them without any trouble.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect 

And In such cases, software like Pabbly Connect is a real help that lets you connect both the application without using a single line of code. Pabbly Connect lets you build seamless workflows for data transmission in real-time.

Not just this, you can create complex workflows with ease using its Multi-step call features. And it is the only automation software that doesn’t restrict on features by offering unlimited workflows, actions, triggers, and much more even in its free plan.

Here, in this article, we will understand how to create GetResponse contacts from new Google Sheets rows.

How to Create GetResponse Contacts from New Google Sheets Rows (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to Google Sheet

6. Test the Response

7. Setting Action

8. Connecting to GetResponse

9. Paste API key

10. Check Response

So, let’s begin the process.

Step 1: Sign up to Pabbly Connect

Sign Up

Intiate the process of connecting Google Sheet to GetResponse by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Subsequently, either fill-up the details manually or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Further, after logging into the account, click on the “Access Now” button as shown in the above image.

Step 3: Workflow for Google Sheet to GetResponse Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of building a workflow for integration by clicking on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Moreover, add the name of workflow which in our case is “Google Sheet to GetResponse”. Nevertheless, you can always name the workflow according to your requirements.

Step 4: Setting Trigger for Google Sheet to GetResponse Integration

Next, after building a workflow, you have to choose the integration app to add Google Sheet entries as GetResponse subscribers. Pabbly Connect allows you to create unlimited actions within minutes, click here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Google Sheet

The following step is to select “Google Sheet” from the dropdown, then choose the “New Spreadsheet Row” option to append data from the sheet into GetResponse.

(b) Copy the Webhook URL

Copy the Webhook URL

The following step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting Google Sheet with Pabbly Connect

To save subscribers in GetResponse, you gotta paste the copied Webhook URL in the sheet. But before that, you, have to install the Add-on named Pabbly Connect in your Google Sheet.

(a) Create a Google Sheet

Create a Google Sheet

The next thing to do is create a Google Sheet with basic details like first name, last name, and email address. You can select a sheet of your choice too.

(b) Click on Add-ons

Click on Add-ons

Further, in the add-on section, you have to click on the “Get add-ons” button to download the “Pabbly Connect Webhook”.

(c) Find Pabbly Connect in G Suite Market Place

Find Pabbly Connect

After clicking on ‘Get Add-on’ a new window will pop-up. Here in the search bar look for Pabbly Connect Webhooks.

(d) Install Pabbly Connect

Install Pabbly Connect Webhook Add-on

Now just click on the install option and within seconds it will get installed into your Google Sheets.

(e) Press Initial Setup in Google Sheets

Press Initial Setup in Google Sheets

Now, when you click on add-ons, Pabbly Connect Webhook will appear there. Just click on it, it will open certain options, select “Initial Setup” to smooth the whole Google Sheet- GetResponse integration process.

(f) Paste the Webhook URL

Paste the Webhook URL

In addition, a window with two choices, the Webhook URL and Trigger Column, will appear when you press “Initial Set-Up”. In that segment, just paste your copied Webhook URL from Pabbly Connect and mention the trigger column as appropriate. To confirm the integration, then click on the ‘Send Test’ button. Before submitting a test message, make sure to press ‘Capture Webhook Response’ on the Pabbly Connect dashboard.

When the test request is received, a message in red letters will indicate that the data has been submitted.

(g) Click Send On Event In Google Sheets

Click Send On Event In Google Sheets

This is the additional step you have to do, to ensure that every time new data added in the sheet it will automatically appear in your GetResponse account. For this, all you have to do is click on “Send on Event” in the “Add-On” option.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

The entry will appear on the ”Pabbly Connect “ dashboard as soon as you click on the “Send Test“ option. Next, click on the ‘Save’ button.

Step 7: Setting Action for Google Sheet & GetResponse Integration

To make Google Sheet and GetResponse integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select GetResponse

In addition, press the + icon to add an action to the trigger. Here we can pick “GetResponse” from the drop-down. Then choose the method “Create a New Contact”.

(b) Click the Connect Button

Click the Connect Button

Click on the “Connected with GetResponse” button after making all the necessary adjustments. In addition, the permission window will open asking for an API key for which you have to log in to your GetResponse account.

Step 8: Connecting GetResponse to Pabbly Connect

To connect Google Sheet to GetResponse, you need to paste the “API Key” for which you have to log in to your GetResponse account.

(a) Click on Menu Icon in GetResponse Dashboard

Click on Menu Icon in GetResponse Dashboard

After logging to your GetResponse account, click on the “Menu” appearing on the dashboard.

(b) Move to Integartion and API

Move to Integartion and API

Further, click on the “Integration and API” option.

(c) Click on API Option

Click on API Option

When you click on “Integration and API” it will open up the new window. There you will see the “API” option, simply click on it.

(d) Generate and Copy a API Key

Generate and Copy a Key

Now, all you have to do is generate an API key and then simply copy it.

Step 9: Paste API Key in Pabbly Connect Dashboard

You need to move back to the Pabbly Connect dashboard and paste the API key in order to add customer details as subscribers to GetResponse.

(a) Fill API Key

Fill API Key

Now simply paste the copied API key, but before pasting the key don’t forget to mention the API-key string in starting. After pasting the key, simply hit the “Save” button.

(b) Map Field Data

Map Field Data

As you see the app has already fetched the campaign id. Just map the appropriate field from the drop-down region, such as the email field, select the email option, and select the name option for the name field.

(c) Save and Send Test Request

Save and Send Test Request

Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the Google Sheet GetResponse integration.

Step 10: Check Response in GetResponse Dashboard

Check Response in GetResponse Dashboard

Finally, your submission will immediately appear there when you search the contact segment of GetResponse.

You now know how to connect Google Sheet to GetResponse. This is a one-time operation. The online business automation platform, i.e. Pabbly Connect will now do all the manual work.

Conclusion –

Okay! This is our catch on “How to Create GetResponse Contacts from New Google Sheets Rows” using Pabbly Connect. All you have to do is follow all the above-mentioned steps and you can easily connect Google Sheet to GetResponse. With the help of an automation tool, one can easily avoid repetitive tasks. And in such cases, software like Pabbly Connect is a real help that lets you connect unlimited premium apps.

So, don’t wait anymore. Go and grab your access by claiming for a free account.

You May Also Like To Read –

 

Posted on

How to Create Pipedrive Activity for New YouCanBook.me Bookings

How to Create Pipedrive Activity for New YouCanBook.Me Bookings

Tired of searching for a way to create Pipedrive activity for new YouCanBook.me Bookings? If yes, then here you can sit back and relax as we are going to integrate YouCanBook.me with Pipedrive in real-time.

How to Create Pipedrive Activity for New YouCanBook.Me Bookings

So basically, YouCanBook.me is an online booking platform which enables people to create bookings easily. On the other hand, Pipedrive is a CRM tool that assists businesses with marketing and other sales processes. Therefore, most of the people want their bookings to auto-populate in Pipedrive to outgrow their business by generating leads. And in such a hectic life, adding booking manually is a hell lot of work to do. Thus, to save you out from such troubles, applications like Pabbly Connect comes into play.

Pabbly Connect helps you to create a smooth workflow between several services by integrating them just once for easy for data transmission. Besides, this app is very easy to use and doesn’t require any technical skills.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect   

In just a few minutes,we will understand how to create Pipedrive activity for new YouCanBook.me bookings in real-time. Furthermore, this software is packed with features for making data transfer a cakewalk. Apart from that,  it also provides features such as routers, path-routers, instant triggers, etc even in its free plan.

Here, in this article, you will be able to integrate YouCanBook.me with Pipedrive using Pabbly Connect. And, all the booking data will get transfer in real-time.

How to Create Pipedrive Activity for New YouCanBook.me Bookings (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Response

7. Setting Action

8. Check Response

So, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Let’s begin the process to create Pipedrive activity for the new YouCanBook.Me bookings by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Moreover, either fill-up the details manually, or else you can sign up via the Gmail account.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Next, after logging into the account, tap on the “Access Now” button as shown in the above image.

Step 3: Workflow for YouCanBook.me & Pipedrive Integration

(a) Start with a New Workflow

Create New Workflow

Begin the process of building a workflow for integration by pressing on the “Create New Workflow” button.

(b) Name the Workflow

YouCanBook.Me to Pipedrive Workflow

Next, add the name of the workflow that is “YouCanBook.me to Pipedrive”. Even though, you can always change its name as per your requirement.

Step 4: Setting Trigger for YouCanBook.me to Pipedrive Integration

Once you create a workflow, now you have to select the integration app to create a YouCanBook.me booking. Pabbly Connect enables you to create infinite workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

The following step is to select “YouCanBook.me” from the dropdown, then choose the “New Booking” option to add the data from the software into Pipedrive.

(b) Copy the Webhook URL

Copy the Webhook URL

The succeeding step is to copy the webhook URL.

Step 5: Connecting YouCanBook.me to Pabbly Connect

Later on, to create Pipedrive activity for new YouCanBook.me bookings, you need to paste the copied Webhook URL in the software. Hence to do that, first, you need to log in to your YouCanBook.me account.

(a) Create a New Booking

Create a New Booking

In the YouCanBook.me dashboard, you can either create a new booking or else choose from the given templates of booking by simply clicking on them.

(b) Click on Edit Option

Click on Edit Option

Next, tap on the “Edit” option of the booking that you wish to add to Pipedrive activity.

(c) Go to Notifications

Go to Notifications

Following that, now go to the notifications section by pressing on the “Notifications” option.

(d) Click on “After New Booking Made” Option

Click on "After New Booking Made" Option

Subsequently, tap on the “After new booking made” option, which will offer some options including the (+) button to add other integrations. Just hit the “(+)” button to move forward.

(e) Tap on the Webhook Option

Tap on the Webhooks Option

After clicking on the (+) button, you will see a “Webhook” option, just tap on that option.

(f) Paste the Copied URL

Paste the Copied URL

Later on, paste the copied URL of Pabbly Connect in the Box named URL, and in the HTTP method, select the “POST” option.

(g) Click on Save Changes

Clilck on Save Changes

Now, in the Payload section, add some codes associated with the form details that you want to add in the Pipedrive activity. Once you are done making all the changes, simply tap on the button named “Save Changes”.

(h) Go to Live Booking Page

Go to Live Booking Page

Next, to test the workflow, you will need to make a booking in YouCanBook.me account. And for that, just go to the booking page by pressing on the “Live booking page” option in the side panel.

(i) Fillup the Booking Form

Fillup the Booking Form to Create Pipedrive Activity for New YouCanBook.me Bookings

Now, enter all the details of the booking form & click on the “Confirm Booking” button. But before that, make sure that you’ve clicked on the “Capture Webhook Response” button in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response in Pabbly Connect Dashboard to Create Pipedrive Activity for New YouCanBook.me Bookings

After filling the form, the booking entry will appear on the “Pabbly Connect” dashboard. Following that, simply tap on the “Save” option.

Step 7: Setting Action for YouCanBook.me & Pipedrive Integration

Consequently, after setting trigger, now it’s time to set an action. And for that, you need to select the integration app to send YouCanBook.me booking to PipeDrive. Pabbly Connect allows you build unlimited workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application You Want to Integrate

Select Application You Want to Integrate to Create Pipedrive Activity for New YouCanBook.me Bookings

In order to create Pipedrive activity for new YouCanBook.Me bookings, click the (+) button. Then select the ‘Pipedrive’ app to integrate from the ‘Choose App’ and select the method as ‘Create Activity’. Then click the ‘Connect’ button.

(c) Go to Pipedrive Settings

Pipedrive Settings

Afterward, you’ll need an API key to complete the connection. So, go to the ‘Company Setting’ by pressing on the profile icon present at the top-right corner of the page.

(d) Copy the API Token

Copy the API Token

On the company settings page, you’ll see a secondary vertical menu. Simply tap on the ‘Personal Preferences’ option from the menu. Following that, press the ‘API’ option in the personal preference’s horizontal menu. Finally, copy the API token from here.

(e) Paste the API Token

Paste API Token

Now, paste the copied API token in Pabbly Connect & click on the ‘Save’ button.

(f) Map the Values

Map the Values to Create Pipedrive Activity for New YouCanBook.me Bookings

First of all, add a subject of the activity in our case i.e, “YouCanBook.me to PipeDrive” and then map all the required fields from the YouCanBook.me to Pipedrive. After that, just tap on the ‘Save & Send Test Request’ button.

(g) Test the Submission and Save

Test the Submission and Save to Create Pipedrive Activity for New YouCanBook.me Bookings

You can check the response of your API in the action window and the Webhook is working perfectly. So, simply save the webhook by pressing the “Save” button in the trigger window.

Step 8: Check Response in Pipedrive

Check the Entry in Pipedrive to Create Pipedrive Activity for New YouCanBook.me Bookings

Also, you can check the entry of a new done in your connected Pipedrive account.

Wind-Up

Well, this is all about ‘How to Create Pipedrive Activity for New YouCanBook.me Bookings’. Subsequently, after completing the step by step procedure, your all the new YouCanBook.me bookings will get automatically updated in your Pipedrive account as an activity. Moreover, the procedure is quite simple and easy to implement.

Besides, you don’t need any coding knowledge to follow the steps. You can always try Pabbly Connect for FREE. In case you have any questions, do write to us in the comment section below. We’ll get back to you ASAP.

You May Also Like to Read:

Posted on

How to Add ActiveCampaign Contacts for New YouCanBook.me Bookings

How to Add ActiveCampaign Contacts for New YouCanBook.me Bookings

Have you ever gave a thought to add ActiveCampaign contacts for new YouCanBook.me bookings? Yes, you might have. This is why we are suggesting a way to integrate YouCanBook.me and ActiveCampaign using Pabbly Connect.

How to Add ActiveCampaign Contacts for New YouCanBook.me Bookings

But before moving forward, let’s put a glance at why there is a need for integrating YouCanBook.me and ActiveCampaign. We all know YouCanBook.me is an online scheduling platform. Whereas ActiveCampaign is a marketing automation and CRM tool.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect     

By connecting ActiveCampaign with YouCanBook.me, you can save bookings as a lead in ActiveCamapign which can be used in different marketing campaigns as well. Doing all this task manually can be a lot of work which is exactly why we are proposing a business automation tool named Pabbly Connect.

Pabbly Connect smoothes the whole integration process by letting you connect different premium applications in a matter of time without using a single line of code. Not just this, it offers various features like unlimited workflows, triggers, actions, and much more even in its free plan.

Here, in this article, we will learn how to add ActiveCampaign contacts for new YouCanBook.me bookings in real-time.

How to Add ActiveCampaign Contacts for New YouCanBook.me Bookings (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Response

7. Setting Action

8. Connecting to ActiveCampaign

9. Paste API key

10. Check Response

So, let’s headstart the process.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process of connecting YouCanBook.me to ActiveCampaign by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Subsequently, either fill-up the details manually or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Further, after logging into the account, click on the “Access Now” button as shown in the above image.

Step 3: Workflow for YouCanBook.me to ActiveCampaign Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of building a workflow for integration by clicking on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Moreover, add the name of workflow which in our case is “YouCanBook.me to ActiveCampaign”. Nevertheless, you can always name the workflow according to your requirements.

Step 4: Setting Trigger for YouCanBook.me to ActiveCampaign Integration

Next, after building a workflow, you have to choose the integration app to collect your YouCanBook.me entries. Pabbly Connect allows you to build unlimited actions within minutes, click here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select YouCanBook.me

The following step is to select “YouCanBook.me” from the dropdown, then choose the “New Booking” option to add the data from the software into ActiveCampaign.

(b) Copy the Webhook URLCopy the Webhook URL

The following step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting YouCanBook.me to Pabbly Connect

To save new bookings from YouCanBook.me into ActiveCampaign contacts, you need to paste the copied Webhook URL in the software. Hence to do that, just log in to your YouCanBook.Me account.

(a) Select Your Booking Page

Select Your Booking Page

Either create or new booking page or select an existing booking page. Then click on the “Edit” option.

(b) Head to Notification Section

Head to Notification Section

When you click on the ”Edit” option, it will open up different options, just click on “Notifications”.

(c) Choose After Booking Made Option

Choose After Booking Made Option

Since we are making this workflow for a new booking, so we will pick “After New Booking Made” option.

(d) Click on “+” Icon

Click on “+” Icon

The next step is to tap on the “+” icon so that you can paste the copied URL.

(e) Select the “Webhook” Option

Select the “Webhook” Option

Now, you have to select the action type, as we are saving all the new bookings as subscribers in ActiveCampaign so we are going to choose “Webhook” option.

(f) Paste the Copied Webhook

Paste the Copied Webhook

Just paste the copied Webhook from Pabbly Connect in the URL section and select the HTTP method as “Post”. You will notice Payload codes after pasting Webhook. After doing all this, hit The “Save Changes” button.

(g) Make Dummy Booking

Make Dummy Booking

Now go to the live booking page and make a dummy entry. After filling all the details hit the “Confirm Booking” button. But before hitting the “Confirm Booking” option, make sure to click on “Capture Webhook Response” in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

As soon as you confirm the booking, the details will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option.

Step 7: Setting Action for YouCanBook.me & ActiveCamapign Integration

To make this YouCanBook.me – ActiveCampaign integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select ActiveCampaign

Next, click on the “+” icon then select “Active Campaign” and in the choose method option, select ”Create a Contact”.

(b) Click the Connect Button

Click the Connect Button

Click on the “Connected with ActiveCampaign” button after making all the necessary modifications. In turn, the authentication window will open that will ask for API Key and URL for which you have to log-in to your ActiveCampaign account.

Step 8: Connecting ActiveCampaign to Pabbly Connect

To connect YouCanBook.me to ActiveCampaign, you need to paste the “API” for which you have to log in to your ActiveCampaign account.

(a) Click on ActiveCampaign Settings

Click on ActiveCampaign Settings

After login, click on the “Settings” on the left side of the bottom section of the dashboard.

(b) Go to Developer Section

Go to Developer Section

When you click on “Settings” it will open up the tab There you will see the “Developer” option, simply click on it.

(c) Copy the API Key and URL

Copy the API Key and URL

Just copy the API and URL appearing on the dashboard.

Step 9: Paste API Key in Pabbly Connect Dashboard

To add customer’s data as subscribers in ActiveCampaign, you have to head back to the Pabbly Connect dashboard to paste the API key and URL.

(a) Fill API Key

Fill API Key

Just paste API Key, and in the “URL” column, mention URL. After ensuring all this, click the “Save” button.

(b) Map Field Data

Map Field Data

Just map the required field from drop-down such as for the email field, select the email option, and for the name field select the name option.

(c) Save and Send Test Request

Save and Send Test Request

Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the YouCanBook.me and ActiveCampaign integration.

Step 10: Check Response in ActiveCampaign Dashboard

Check Response in ActiveCampaign Dashboard

Lastly, when you check the Contact section in ActiveCampaign, your entry will automatically appear there.

Now you know how to add YouCanBook.me new booking to ActiveCampaign in real-time. This is a one-time process, now all your manual work will be done by the online business automation tool i.e Pabbly Connect.

Conclusion –

That’s it! This was our take on “How to add ActiveCampaign contacts for new YouCanBook.me bookings” using the software. We realize how daunting a method of connecting two applications can be. This is why individuals are searching for resources that can support them. And, trust us, one of the better Zapier alternatives available on the market is Pabbly Connect, which doesn’t put a hole in your wallet. Even during your free trial, you’ll have access to everything.

All right, just what’s stopping you now! By signing up for a free account, go and catch a deal.

You May Also Like To Read –

Posted on

How to Add New YouCanBook.me Bookings to Pipedrive as Deals

How to Add New YouCanBook.Me Bookings to Pipedrive as Deals

In this blog, we are going to proceed the step by step procedure to add all the newly added YouCanBook.me bookings to the Pipedrive deals automatically.

We are going to integrate YouCanBook.me with Pipedrive using Pabbly Connect to send the booking’s data to create a deal automatically. Pabbly Connect enables connecting two or more services to shares data in real-time.

How to Add New YouCanBook.me Bookings to Pipedrive as Deals

We’ll set up a trigger on the YouCanBook.me new bookings and its respective action for creating deals on Pipedrive.

Also, Pabbly Connect provides instant triggers, routers, filters and formatters to design limitless workflows. Further, it also allows you to use many advanced options like multi-step calls, integration with unlimited premium apps etc. And all this without writing a single line of code or help from a professional.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect  

In a few minutes interval, it allows you to add the freshly scheduled bookings as deals from YouCanBook.me to Pipedrive. So, save your time and access all Pabbly Connect features without any restriction even in its free plan.

Now, let’s move forwards with the step by step procedure to integrate YouCanBook.me to Pipedrive and automatically add the newly added bookings as deals.

How to Add New YouCanBook.me Bookings to Pipedrive as Deals (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create a Workflow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Trigger

7. Setting Action

8. Save the Workflow

Step 1: Sign up to Pabbly Connect

Sign Up

Visit the official website of Pabbly Connect & then hit the ‘Sign-Up Free‘ button. Next, on the registration page signup using an existing Google account or manually fill in the form to get into the system.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ Pabbly application.

Step 3: Workflow for YouCanBook.me with Pipedrive Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to add new YouCanBook.me bookings to Pipedrive as deals and to do this strike the ‘Create New Workflow’ button.

(b) Name the Workflow

YouCanBook.Me to Pipedrive Workflow

Now, name the workflow as per your need (for instance: YouCanBook.me to Pipedrive etc) and push the ‘Save’ button.

Step 4: Setting Trigger for YouCanBook.me – Pipedrive Integration

To automatically add new YouCanBook.me bookings to Pipedrive as deals whenever a booking happens, you need to set-up a trigger on ‘New Booking’ and its respective action to add the customer’s details as a deal in Pipedrive.

(a) Select Application you want to integrate

Integrate YouCanBook.Me

When you hit the save button to create a workflow, a trigger window will open next.

You’ll need to select the ‘YouCanBook.me’ option from the ‘Choose App’ field drop-down options.

(b) Copy the Webhook URL

Copy Webhook URL

Check, the method in here to be ‘New Booking’ & copy the ‘Webhook URL’ by clicking the ‘Copy’ button on this page.

Up to this point, we are half-way done with the YouCanBook.me to Pipedrive integration’s trigger. And now, we’ll need to paste this URL on our YouCanBook.me settings to get the trigger working.

Step 5: Connecting YouCanBook.me to Pabbly Connect

To connect your YouCanBook.me account and Pabbly Connect. First, sign-in into your YouCanBook.me account.

(a) Go to Your YouCanBook.me Account

Create a Booking Page

After signing in to your YouCanBook.me account, click the plus button to create a booking page.

(b) Assign a Booking Page Title

Booking Page Title

Click on the ‘Edit’ button of the recently created booking page and assign a ‘Booking Page Title’.

(c) Go to Your YouCanBook.me Webhook Settings

YouCanBook.Me Settings

Next, click the ‘Notification’ option from the left vertical menu and then click on ‘After the new booking made’. And then click the plus button.

(d) Click on ‘Webhook’ Button

Click on Webhook

A small pop-up will open up carrying some buttons, click on the ‘Webhook’ button.

(e) Paste Webhook URL

Paste Webhook URL

Now, paste the copied Webhook URL form Pabbly Connect in the ‘URL’ field here. Also, select the HTTP method as ‘POST’.

(f) Click on the ‘Save Changes’ Button

Click Save Changes

Lastly, click on the ‘Save changes’ button on this page.

Step 6: Test the Trigger Response in Pabbly Connect Dashboard

As we can see we are done setting up the trigger to send order data when a new booking is made through YouCanBook.me. So now, let’s just test the trigger by making a test order on YouCanBook.me.

(a) Capture Webhook Response

Capture Webhook Response

To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.

(b) Go to the YouCanBook.me Account’s Live Booking Page

Live Booking Page

Open the YouCanBook.me booking page by hitting the ‘Live Booking Page’ option from the left verticle menu.

(c) Select Date & Time

Select Date & Time

Next, click select the date and time for booking a slot.

(d) Confirm the Booking

Confirm Booking

Feed all the required details to complete the booking and lastly hit the ‘Confirm Booking’ button.

(e) Check Trigger API’s Response

Trigger Response

Check the captured trigger response in the Pabbly Connect trigger window. You can sell all the data fed in the booking in the response clearly.

Step 7: Setting Action for YouCanBook.me – Pipedrive Integration

As we can see the response that we got of the set trigger is as expected and now we can move forward towards taking an action on the received data from YouCanBook.me.

(a) Select Application You Want to Integrate

Integrate Pipedrive

To start adding new YouCanBook.me bookings to Pipedrive as deals, click the plus button next to your recently created trigger window.

Then select the ‘Pipedrive’ app to integrate from the ‘Choose App’ field’s drop-down menu.

(b) Connect with Pipedrive

Connect with Pipedrive

Next, select the method in here to be ‘Create Deal’ and then click ‘Connect with Pipedrive’ button.

(c) Go to Pipedrive Settings

Pipedrive Settings

Next, you’ll need an API key to complete the connection. So, go to the ‘Company Setting’ by clicking the profile icon present at the top-right corner of the page.

(d) Copy the API Token

Copy the API Token

On the company settings page, you’ll see a secondary vertical menu. Click the ‘Personal Preferences’ option from the menu.

Next, hit the ‘API’ option in the personal preference’s horizontal menu.

Lastly, copy the API token from here.

(e) Paste the API Token

Paste API Token

Paste the copied API token in Pabbly Connect and push the ‘Save’ button to establish a connection.

(f) Map the Values

Map The Values

First, assign a title to the deal and then map all the required fields from the YouCanBook.me to Pipedrive deal.

To map a value from the response, simply place your cursor on the field and then click the menu icon or three verticle lines present right next to that particular field.

(g) Save & Send Test Request

Save & Send Test Request

After mapping all the necessary fields, click on the ‘Save & Send Test Request’ button.

(h) Check the Action API’s Response

Action API Response

You can check the response of your API in the action window.

(i) Check the Entry in Pipedrive

Check Entry in Pipedrive

Also, you can check the entry of a new done in your connected Pipedrive account.

Step 8: Save the Workflow

(a) Save the Action API’s Response

Save Action API's Response

Save the action API’s response by hitting the ‘Save’ button at the bottom of the action API’s response.

(b) Save the Workflow

Save Webhook

As we can see the Webhook is working perfectly. So, simply save the webhook by clicking the save button in the trigger window.

Wind-Up

Well, this is all about ‘How to add new YouCanBook.me bookings to Pipedrive as deals’. Consequently, after completing the step by step procedure, you will end up adding all the new YouCanBook.me bookings to your Pipedrive account as deals. Most importantly, the procedure is very easy to implement and you don’t need any coding knowledge to follow the steps.

You can always try Pabbly Connect for FREE.

For any further questions, do comment below. We’ll get back to you ASAP.

You May Also Like to Read:

Posted on

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Do you want to know if Google Sheets can be updated automatically on every YouCanBook.me rescheduled bookings? If yes, then this blog is the correct stop for you as here we will be integrating Google Sheets with YouCanBook.me via Pabbly Connect.

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Before we get into the integration process, let’s know a little bit about these two services quickly. Google Sheets is an online spreadsheet program that lets you create and format spreadsheets and work with other people. On the other hand, YouCanBook.me is an online appointment scheduling software that works directly with Google, iCloud, and Microsoft cloud calendars.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect

To integrate these two apps, we are using Pabbly Connect, which is an amazing software through which you can integrate unlimited applications easily. After this integration, every time when you will reschedule booking in your YouCanBook.me account, the information will automatically be updated in your Google Sheets.

Pabbly Connect also comes with many other great features:

  • Create unlimited workflows without any restrictions
  • Unlimited premium apps
  • Set unlimited triggers, unlimited actions to those triggers
  • Path Routers

and the best part is that you can access all the features even with the free plan.

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Reschedule Booking

7. Test the Response

8. Setting Action

9. Connecting to Pabbly Connect

10. Check Response

Hence, let’s not waste anymore of your time and get into the blog about how to add YouCanBook.me rescheduled bookings to Google Sheets.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process to add YouCanBook.me rescheduled bookings to Google Sheets by visiting the website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect.

Step 3 : Workflow for Google Sheets with YouCanBook.me Integrations

(a) Create New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button.

(b) Name the Workflow

Name the Workflow

Now, you need to name the workflow just like in the above-shown image. I named the workflow as “YouCanBook.me to Google Sheets”, you can obviously name the workflow as per your requirements and needs.

Step 4 : Setting Triggers for Google Sheets with YouCanBook.me Integrations

After creating a workflow, you have to select the application you want to integrate. Using Pabbly Connect, you can integrate any two or more than two applications, create your free account now.

(a) Select Application you want to Integrate

Select Youcanbookme

Now, you have to select the application that you want to integrate. In this case, we are choosing “YouCanBook.me” for integration. After selecting the application select “Rescheduled Booking” in the choose method section.

(b) Copy the Webhook URL

Copy the Webhook URL

After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process.

Step 5 : Connecting YouCanBook.me to Pabbly Connect

To connect with YouCanBook.me, you have to paste the copied Webhook URL in the software. For that, you need to log into your YouCanBook.me account.

(a) Select a Booking Page

Select Booking

Here, you can select any booking page that you want to integrate.

(b) Click on Notifications

Click on Notifications

After selecting the booking page, now you have to click on “Notifications”, then a page will appear with certain options, you have to click on “If Booking Rescheduled” option. After selecting these options, now you have to click on the “+” sign of the “By you” section.

(c) Click on Webhook

Click on Webhook

After you click on the “+” button, a dialogue box will appear, here you have to click on “Webhook”.

(d) Paste the Webhook URL

Paste the Webhook URL

Next, you have to paste your webhook URL and change the HTTP method to “POST”. After making all changes, click “Save Changes” button.

Step 6 : Reschedule a Booking

To test this integration, we will be rescheduling a booking to check if the integration is working or not.

(a) Select a Booking

Reshedule Booking

Select a booking that you want to reschedule and click on the “Details” button and then select “Reschedule” option.

(b) Confirm Reschedule

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Select any date and time that you want to reschedule the booking and then click on the “Confirm Reschedule” button. But before clicking the button, click on the “Capture Webhook Response” in Pabbly Connect.

Step 7 : Test the Submission in Pabbly Connect Dashboard

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

As soon as you click on the “Confirm Reschedule” in YouCanBook.me and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option.

Step 8 : Setting Action for Google Sheets with YouCanBook.me Integrations

In this step, we will be adding an action for your trigger to complete this integration process.

(a) Select Application you want to Integrate

Select Google Sheets

Now in this step, click on the + button below and choose “Google Sheets” and in the method section select “Add New Row”.

(b) Click on Connect Button

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

After choosing the application click on the “Connect” button to move forward.

Step 9 : Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, you need to authorize your Google account through which you want to connect.

(a) Authorize Application

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

When you click on the “Connect” button, a window will slide in from the right, here you have to again click on the “Connect” button and then choose the account through which we want to integrate Google Sheets.

(b) Map the Fields

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Once you are connected with your Google account, now you have to add all the field’s data like name, email id, etc. Map up all the fields quickly.

(c) Send a Test Request

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Once you are done mapping up all fields click on the “Save & Send Test Request” button and then save your workflow.

Step 10 : Check Response in Google Sheets

How to Add YouCanBook.me Rescheduled Bookings to Google Sheets

Here, you can see the integration was successful and the rescheduled booking has been added to your Google Sheet automatically. Now because of this integration, whenever you will reschedule any booking in YouCanBook.me, the info will be automatically updated in your Google Sheets.

Conclusion –

To conclude, this was our take on how to add YouCanBook.me rescheduled bookings to Google Sheets. Through Pabbly Connect, you can integrate thousands of applications to automate your workflows and get rid of the stress of doing the redundant work. The awesome part of this service is that you can enjoy this extremely smooth software for free as well. Therefore to change your working experience sign up for your free account now and relax as Pabbly Connect is here to do all the heavy lifting for you.

In case of any queries or suggestions, leave your comments below. We will try to get back to you as soon as possible.

You May Also Like to Read –

Posted on

How to Add Google Sheets Row for Cancelled YouCanBook.me Bookings

How to Add Google Sheets Row for Cancelled YouCanBook.me Bookings

Want to know a way to add Google Sheets row for cancelled YouCanBook.me bookings? If yes, then here in this blog we will integrate YouCanBook.me and Google Sheet using Pabbly Connect.

How to Add Google Sheets Row for Cancelled YouCanBook.me Bookings

But let’s first put light on why there is a need for YouCanBook.me and Google Sheet integration. We all know that it is an online scheduling tool that removes all manual work of sending emails individually. But what if you want to create a spreadsheet of all the bookings including cancelled ones.

Believe us, it is a lot of work, filling every detail manually can drive us crazy. This is why we are recommending a business automation tool named Pabbly Connect.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect    

Pabbly Connect simplifies boring or recurring activity by creating seamless workflows. Plus, you don’t need any technical knowledge to use the application.

Within 5 minutes, Pabbly Connect is ready to rule, without any installation setup. It lets you obtain cancelled YouCanBook.me bookings and send the results to Google Sheets in real-time. Is this not fantastic?

Yeah, it is, plus the software is loaded with options like unlimited workflow, action, triggers, etc to smooth the whole data transfer process. Even in its free plan, it provides features such as path-routers, instant triggers, and many more.

How to Add Google Sheets Row for Cancelled YouCanBook.me Bookings (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Response

7. Setting Action

8. Check Response

Here, in this article, we will learn how to add Google Sheets row for cancelled YouCanBook.me bookings in real-time.

So, let’s headstart the process.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process of connecting Google Sheet to YouCanBook.me by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Subsequently, either fill-up the details manually or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Further, after logging into the account, click on the “Access Now” button as shown in the above image.

Step 3: Workflow for YouCanBook.me to Google Sheet Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of building a workflow for integration by clicking on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Moreover, add the name of workflow which in our case is “YouCanBook.me to Google Sheet”. Nevertheless, you can always name the workflow according to your requirements.

Step 4: Setting Trigger for YouCanBook.me to Google Sheet Integration

Next, after building a workflow, you have to choose the integration app to collect your YouCanBook.me cancelled entries. Pabbly Connect allows you to build unlimited workflows within minutes, click here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select YouCanBook.Me

The following step is to select “YouCanBook.me” from the dropdown, then choose the “Cancelled Booking” option to add the data from the software into Google Sheets.

(b) Copy the Webhook URL

Copy the Webhook URL

The next step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting YouCanBook.me to Pabbly Connect

To save cancelled bookings from YouCanBook.me into Google Sheet, you need to paste the copied Webhook URL in the software. Hence to do that, just log in to your YouCanBook.Me account.

(a) Select Your Booking Page

Select Your Booking Page

Either create or new booking page or select an existing booking page. Then click on the “Edit” option.

(b) Head to Notification Section

Head to Notification Section

When you click on the”Edit” option, it will open up different options, just click on “Notifications”.

(c) Choose If Booking Cancelled Option

Choose If Booking Cancelled Option

Since we are making this workflow for cancelled booking, so we will pick “If Booking Cancelled” option.

(d) Click on “+” Icon

Click on "+" Icon

The next step is to tap on the “+” icon so that you can paste the copied URL.

(e) Select the “Webhook” Option

Select the "Webhook" Option

Now, you have to select the action type, as we are saving all the cancelled bookings in Google Sheet so we are going to choose “Webhook” option.

(f) Paste the Copied Webhook

Paste the Copied Webhook

Just paste the copied Webhook from Pabbly Connect in the URL section and select the HTTP method as “Post”. After making sure of this, hit The “Save Changes” button.

(g) Make Dummy Booking

Make Dummy Booking

Now go to live booking page and make dummy entry. After filling all the details hit the “Confirm Booking” button.

(h) Cancel Booking

Cancel Booking

Next, head back to booking section, all the entries will appear there. Then to cancel a booking, click on “Details” and select “Cancel”. But before hitting the “Cancel” option, make sure to click on “Capture Webhook Response” in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

As soon as you cancel the booking, the details will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option.

Step 7: Setting Action for YouCanBook.me & Google Sheet Integration

To make this YouCanBook.me – Google Sheet integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Google Sheets

Next, click on the “+” icon then select “Google Sheet” and in the choose method option, select ” Add New Row”.

(b) Click the Connect Button

Connected with Google Sheets

Click on the “Connected with Google Sheet” button after making all the necessary modifications. In turn, the authentication window that you use to log in to your Google account would open.

(c) Map Field Data

Map Field Data

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “YouCanBook.me Bookings”. Now, all you have to do is add the necessary field from drop-down such as for the name, select the name option, and for the email field select the email.

(d) Save and Send Test Request

Save and Send Test Request

Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the Cognito Forms and Google Sheet integration.

Step 8: Check Response in Google Sheet

Check Response in Google Sheet

Lastly, when you check the Google Sheets, the cancelled entry get auto-populated in a sheet.

Now you know how to integrate Google Sheets with YouCanBook.me bookings. This is a single-time process, after this every time when a booking gets cancelled, it will get auto-populated in the sheet.

Conclusion –

That’s that! Here we have cleared all the air about the automation process. In this post, we learned how to add Google Sheets row for cancelled YouCanBook.me bookings in real-time. All you have to do is follow all the steps listed above and you can connect YouCanBook.Me to Google Sheets quickly. One can easily avoid monotonous work with the help of automation. And in those situations, software like Pabbly Connect is true salvation that allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like To Read –

Posted on

How to Create Google Sheets Rows for YouCanBook.me Bookings

How to Create Google Sheets Rows for YouCanBook.me Bookings

Tired of searching for a way to create Google Sheets rows for YouCanBook.me Bookings? If yes, then here you can sit back and relax as we are going to integrate YouCanBook.me with Google Sheets in real-time.

How to Create Google Sheets Rows for YouCanBook.me Bookings

We all know YouCanBook.me is an online booking platform that allows you to create bookings in just a couple of minutes. However, several times people want bookings to auto-populate in Google Sheets. And in such a hectic life, filling every single booking manually is a hell lot of work to do. This is where apps like Pabbly Connect comes into play.

By building smooth workflows, Pabbly Connect simplifies boring or repeated behavior. Plus, to use the app, you don’t require any technical expertise.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect   

In just a few minutes, you will be able to integrate YouCanBook.me with Google Sheets using Pabbly Connect. And, your all the booking data will get tranfer in real-time.

Moreover, this software is packed with tools for making data transfer a cakewalk. Not only that, but it also offers features like routers, path-routers, instant triggers, and many more even in its free plan.

Here, in this article, we will understand create Google Sheets rows for YouCanBook.me bookings in real-time.

How to Create Google Sheets Rows for YouCanBook.me Bookings (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouCanBook.me

6. Test the Response

7. Setting Action

8. Check Response

So, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process of connecting YouCanBook.me to Google Sheet by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Further, either fill-up the details manually or else you can sign up via Gmail account.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Following that, after logging into the account, press on the “Access Now” button as shown in the above image.

Step 3: Workflow for YouCanBook.me & Google Sheet Integration

(a) Start with a New Workflow

Create New Workflow

Begin the process of building a workflow for integration by pressing on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Furthermore, add the name of workflow which in our case is “YouCanBook.me to Google Sheet”. Although, you can always name the workflow as per your requirements.

Step 4: Setting Trigger for YouCanBook.me to Google Sheet Integration

Subsequently, after building a workflow, you have to select the integration app to make a YouCanBook.me booking. Pabbly Connect allows you build unlimited workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

The next step is to select “YouCanBook.me” from the dropdown, then choose the “New Booking” option to add the data from the software into Google Sheets.

(b) Copy the Webhook URL

Copy the Webhook URL

The subsequent step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting YouCanBook.me to Pabbly Connect

Moreover, in order to save create Google Sheets for YouCanBook.me bookings, you need to paste the copied Webhook URL in the software. And to do so, you need to log in to your YouCanBook.me account.

(a) Create a New Booking

Create a New Booking

In the YouCanBook.me dashboard, you need to create a new booking, or else you can choose from the given templates of booking by simply clicking on them.

(b) Click on Edit Option

Click on Edit Option

Now, the next thing is to click on the “Edit” option of the booking that you are going to add in Google Sheets rows.

(c) Go to Notifications

Go to Notifications

Moving forward, now its time to go to the notifications section by clicking on the “Notifications” option.

(d) Click on “After New Booking Made” Option

Click on "After New Booking Made" Option

Next, all you need to do is tap on the “After new booking made” option, which will offer some options along with a (+) button to add other integrations. Just click on the “(+)” button to move forward.

(e) Tap on the Webhook Option

Tap on the Webhooks Option

Once you click on the (+) button, you will see a “Webhook” option, simply tap on that option.

(f) Paste the Copied URL

Paste the Copied URL

After that, you need to paste the copied URL of Pabbly Connect in the Box named URL, and in the HTTP method, you need to select the “POST” option.

(g) Click on Save Changes

Clilck on Save Changes

Now, in the Payload section, you need to add some codes associated with the form details that you want to add in the Google Sheets rows. After making all the changes, just click on the button named “Save Changes”.

(h) Go to Live Booking Page

Go to Live Booking Page

Now, in order to test the workflow, you will need to make a booking in YouCanBook.me account. And to do so, you need to go to the booking page by clicking on the “Live booking page” option in the side panel.

(i) Fillup the Booking Form

Fillup the Booking Form to Create Google Sheets Rows for YouCanBook.me Bookings

Now, its time to fill all the details of the booking form and hit the “Confirm Booking” button. But before that, you need to make sure that you’ve clicked on the “Capture Webhook Response” button in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response in Pabbly Connect Dashboard to Create Google Sheets Rows for YouCanBook.me Bookings

After filling the form, the booking entry will appear on the “Pabbly Connect” dashboard. Next, press the “Save” option.

Step 7: Setting Action for YouCanBook.me & Google Sheet Integration

Consequently, in order to make this YouCanBook.me and Google Sheet integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate to Create Google Sheets Rows for YouCanBook.me Bookings

Further, click on the “+” icon then select “Google Sheet” and in the choose method option, select ” Add New Row”. After that, you need to click on the button named “Connect” to authorize it with Google account.

(b) Click the Connect Button

Click the Connect Button to Create Google Sheets Rows for YouCanBook.me Bookings

Once you press the “Connected with Google Sheet” button, it will open the authorization window, for which you have to log in to your Google account.

(c) Map Field Data

Map Field Data to Create Google Sheets Rows for YouCanBook.me Bookings

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “Sheet1”. Now, all you have to do is add the necessary field from drop-down such as for the name, select the name option, and for the email field select the email. Then, map the start date-time along with end date-time. Later, just click on the button named “Save & Send Test Request”.

(d) Test the Submission and Save

Test the Submission and Save to Create Google Sheets Rows for YouCanBook.me Bookings

Subsequently, once you hit the “Send Test Request”, all the entries will be sent to Google Sheets Rows. Just click on the “Save” button to save the entire workflow.

Step 8: Check Response in Google Sheet

Check Response in Google Sheet to Create Google Sheets Rows for YouCanBook.me Bookings

Finally, when you check the Google Sheets, the entered details get auto-populated in a sheet.

Now you know how to create Google Sheets Rows for YouCanBook.me Bookings. This is a one-time process, after this whenever a booking will be made via YouCanBook.me account will get auto-populated in the Google Sheets rows.

Conclusion –

Hopefully, now you know how to create Google Sheets Rows for YouCanBook.me Bookings in real-time. All you have to do is follow all the above-mentioned steps and you can connect YouCanBook.me to Google Sheets quickly. One can easily avoid repetitive work with the help of automation by using software like Pabbly Connect which allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like To Read –

Posted on

How to Shorten URL Address from Google Sheets Rows via Bitly

How to Shorten URL Address from Google Sheets Rows via Bitly

Are you looking for a way to shorten URL addresses from Google Sheets? Then you don’t have to look any further as we have a perfect solution for your problems called Pabbly Connect.

How to Shorten URL Address from Google Sheets Rows via Bitly

Through this wonderful software, you can connect any two or more applications and automate your projects and work without any coding skills. This tool is the key to getting rid of all the redundant work as you have to integrate once and then all your work will be done automatically.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect

In addition to integrations, Pabbly Connect also offers so many useful and beneficial features:

  • Create unlimited workflows without any restrictions
  • Unlimited premium apps
  • Set unlimited triggers, unlimited actions to those triggers
  • Path Routers

and the best advantage of this service is that you can access all the features even with the free plan.

After this integration of Google Sheets with Bitly, you can easily shorten any URL address from your Google Sheets via Bitly automatically. You won’t have to do anything.

How to Shorten URL Address from Google Sheets Rows via Bitly (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to Google Sheets

6.  Test the Submission

7. Setting Action

8. Connecting to Pabbly Connect

9. Setting Action

10. Check Response

Therefore, without further ado let’s get into the blog about how to shorten URL address from Google Sheets rows via Bitly.

Step 1: Sign up to Pabbly Connect

Sign Up

Commence the process to shorten URL address from Google Sheets rows via Bitly by visiting the website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect.

Step 3 : Workflow for Google Sheets with Bitly Integrations

(a) Create New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button.

(b) Name the Workflow

Name the Workflow

Now, you need to name the workflow just like in the above-shown image. I named the workflow as “Google Sheets with Bitly”, you can obviously name the workflow as per your requirements and needs.

Step 4 : Setting Triggers for Google Sheets with Bitly Integrations

After creating a workflow, you have to select the application you want to integrate. Using Pabbly Connect, you can integrate any two or more than two applications, create your free account now.

(a) Select Application you want to Integrate

Select Google Sheets

Now, you have to select the application that you want to integrate. In this case, we are choosing “Google Sheets” for integration. After selecting the application select “New Spreadsheet Row” in the choose method section.

(b) Copy the Webhook URL

Copy the Webhook URL

After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process.

Step 5 : Connecting Google Sheets to Pabbly Connect

To connect with Google Sheets, you have to paste the copied Webhook URL in your Google Sheet Add-ons section.

(a) Create a Google Sheet

Create a Sheet

The very first thing to do is create a Google Sheet with basic details like company name, website URL, etc. You can select a sheet of your choice too.

(b) Click on Add-ons

Click on Add-ons

Further, in the add-on section, you have to click on the “Get add-ons” button to download the “Pabbly Connect Webhook”.

(c) Find Pabbly Connect in G Suite Market Place

Find Pabbly Connect

Now, clicking on ‘Get Add-ons’ a new window will pop-up. Here in the search bar type Pabbly Connect Webhooks.

(d) Install Pabbly Connect

Find Pabbly Connect

Next, simply click on the install option and within seconds it will get installed into your Google Sheets.

(e) Press Initial Setup In Google Sheets

Click on Initial Setup

Now, when you click on add-ons, Pabbly Connect Webhook will appear there. Just click on it and then select “Initial Setup” to paste the copied Webhook URL.

(f) Paste the Webhook URL

How to Shorten URL Address from Google Sheets Rows via Bitly

After selecting the “Initial Set-up” paste the copied webhook URL. Once you have pasted the URL, now you have to mention the trigger column and then click on the “Send Test” button but before hitting the button, click on “Capture Webhook Response” in Pabbly Connect.

Step 6 : Test the Submission in Pabbly Connect Dashboard

How to Shorten URL Address from Google Sheets Rows via Bitly

As soon as you click on the “Send Test” in Google Sheet and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option.

Step 7 : Setting Action for Google Sheets with Bitly Integrations

In this step, we will be adding an action for your trigger to complete this integration process.

(a) Select Application you want to Integrate

Select Bitly

Now in this step, click on the + button below and choose “Bitly” and in the method section select “Shorten Link”.

(b) Click on Connect Button

How to Shorten URL Address from Google Sheets Rows via Bitly

After choosing the application click on the “Connect with Bitly” button to move forward.

Step 8 : Connecting Bitly to Pabbly Connect

To connect Bitly with Pabbly Connect, you need to authorize your Bitly account through which you want to connect.

(a) Authorize Application

How to Shorten URL Address from Google Sheets Rows via Bitly

When you click on the “Connect” button, a window will slide in from the right, here you have to again click on the “Connect” button and then choose the account through which we want to integrate Bitly.

(b) Map the Fields

How to Shorten URL Address from Google Sheets Rows via Bitly

Once you are connected with your Bitly account, now you have to add all the field’s data like group, long URL. Map up all the fields quickly.

(c) Send a Test Request

How to Shorten URL Address from Google Sheets Rows via Bitly

Once you are done mapping up all fields click on the “Save & Send Test Request” button and then save your workflow.

Step 9 : Setting Action for Google Sheets with Bitly Integrations

To complete the workflow, we have to add another action.

(a) Select Application you want to Integrate

Select Google Sheets

Here you have to select “Google Sheets” for the action application. After selecting Google Sheets, select “Lookup Spreadsheet Rows” on the choose method section.

(b) Click on Connect Button

Click Connect

After choosing the application click on the “Connect” button to move forward.

(c) Choose the Sheet

Map the Google Sheets

Now after clicking the connect button, a pop-up will appear on your screen where you have to select the sheet on which you want to update your URL info.

(d) Map the Fields

Map up the Fields

Once you are connected with your Google sheet, now you have to add all the field’s data like lookup column, lookup value. Map up all the fields quickly.

(e) Send a Test Request

Send a Test Request

Once you are done mapping up all fields click on the “Save & Send Test Request” button.

(f) Select Application you want to Integrate

Select G Sheets

Once again we will be adding action and choosing the “Google Sheets” and in the method section we will select “Update Values”.

(g) Click on Connect Button

Click Connect Button

After choosing the application click on the “Connect” button to move forward.

(h) Choose the Sheet

Map the Google Sheets

Now after clicking the connect button, a pop-up will appear on your screen where you have to select the sheet on which you want to update your URL info. You can find sheets according to the date and time they were used.

(i) Map the Fields

Map the Value to Update

Once you are connected with your Google sheet, now you have to add all the field’s data like range, values. Map up all the fields quickly.

(j) Send a Test Request

Send a Test Request

Once you are done mapping up all fields click on the “Save & Send Test Request” button.

Step 10 : Check Response

Check Response

Here, you can see the integration was successful and the URL has been shortened and added to your Google Sheet automatically. Now in a similar way, you can trim bulk URLs in no time with this integration.

Conclusion –

Certainly, this is the finest and simplest way to shorten URL addresses from Google Sheets rows via Bitly. Through Pabbly Connect, you can integrate many applications to automate your workflows and get rid of the strain of doing the same work again and again. The amazing part of this software is that you can enjoy this awesomely smooth service for free as well. Therefore to change your working experience sign up for your free account now and relax as Pabbly Connect is here to do all the work for you.

In case of any queries or suggestions, leave your comments below. We will try to get back to you as soon as possible.

You May Also Like to Read –

Products

Resources

Company Details

Get In Touch

Follow Us

Experience the full range of business solutions with Pabbly, including form creation, email marketing, billing, automation, and much more!
f  Join FB Group
How
How
How

Company

Learn

Partners

Products

Developer

Contact

Follow Us

f  Join FB Group
How
How
How

Developer

Integrations

Certification

Company

Learn

Partners

Products

Follow Us

f  Join FB Group
How
How
How

Developer

Integrations

Certification

MagnetBrains LLC DBA Pabbly © 2024. All Rights Reserved.
Sitemap
MagnetBrains LLC DBA Pabbly © 2024. All Rights Reserved.
Sitemap

Company

Learn

Partners

Products

Follow Us

f  Join Facebook Group
How
How
How

Documentation

Integrations

Certification

MagnetBrains LLC DBA Pabbly © 2025. All Rights Reserved.
Sitemap