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.
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
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.
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
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
Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect. Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button. 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. 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. 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. 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. To connect with Google Sheets, you have to paste the copied Webhook URL in your Google Sheet Add-ons section. 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. Further, in the add-on section, you have to click on the “Get add-ons” button to download the “Pabbly Connect Webhook”. Now, clicking on ‘Get Add-ons’ a new window will pop-up. Here in the search bar type Pabbly Connect Webhooks. Next, simply click on the install option and within seconds it will get installed into your Google Sheets. 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. 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. 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. In this step, we will be adding an action for your trigger to complete this integration process. Now in this step, click on the + button below and choose “Bitly” and in the method section select “Shorten Link”. After choosing the application click on the “Connect with Bitly” button to move forward. To connect Bitly with Pabbly Connect, you need to authorize your Bitly account through which you want to connect. 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. 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. Once you are done mapping up all fields click on the “Save & Send Test Request” button and then save your workflow. To complete the workflow, we have to add another action. Here you have to select “Google Sheets” for the action application. After selecting Google Sheets, select “Lookup Spreadsheet Rows” on the choose method section. After choosing the application click on the “Connect” button to move forward. 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. 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. Once you are done mapping up all fields click on the “Save & Send Test Request” button. Once again we will be adding action and choosing the “Google Sheets” and in the method section we will select “Update Values”. After choosing the application click on the “Connect” button to move forward. 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. 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. Once you are done mapping up all fields click on the “Save & Send Test Request” button. 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. 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.Step 2: Access Pabbly Connect
Step 3 : Workflow for Google Sheets with Bitly Integrations
(a) Create New Workflow
(b) Name the Workflow
Step 4 : Setting Triggers for Google Sheets with Bitly Integrations
(a) Select Application you want to Integrate
(b) Copy the Webhook URL
Step 5 : Connecting Google Sheets to Pabbly Connect
(a) Create a Google Sheet
(b) Click on Add-ons
(c) Find Pabbly Connect in G Suite Market Place
(d) Install Pabbly Connect
(e) Press Initial Setup In Google Sheets
(f) Paste the Webhook URL
Step 6 : Test the Submission in Pabbly Connect Dashboard
Step 7 : Setting Action for Google Sheets with Bitly Integrations
(a) Select Application you want to Integrate
(b) Click on Connect Button
Step 8 : Connecting Bitly to Pabbly Connect
(a) Authorize Application
(b) Map the Fields
(c) Send a Test Request
Step 9 : Setting Action for Google Sheets with Bitly Integrations
(a) Select Application you want to Integrate
(b) Click on Connect Button
(c) Choose the Sheet
(d) Map the Fields
(e) Send a Test Request
(f) Select Application you want to Integrate
(g) Click on Connect Button
(h) Choose the Sheet
(i) Map the Fields
(j) Send a Test Request
Step 10 : Check Response
Conclusion –
You May Also Like to Read –
