Are you looking to add new Workiom records to Google Sheets as rows automatically? If yes, then your search ends here. Through an amazing service called Pabbly Connect, you can easily integrate any two or more than two software without any coding skills.
But before diving into the integration process, let’s first know a little bit about these two software that we are going to connect. So, basically, Workiom is a cloud collaboration service that allows the creation of day-to-day business applications to manage data and workflows. On the other hand, Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs office suite offered by Google within its Google Drive service.
Thus, by integrating these two services, whenever there will be any new record created in Workiom, the info will get automatically updated in Google Sheets. Hence, we are going to use Pabbly Connect for integration.
Pabbly Connect is a fantastic integration and automation software, which allows you to integrate two or more applications and automate all the projects. You just have to do the integration once and then everything will be automatically taken care of by the software.
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 offers 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
Other than the integrations, the software also offers many other useful features:
- Create unlimited workflows without any restrictions
- Unlimited premium apps
- Set unlimited triggers, unlimited actions to those triggers
- Path routers
Moreover, the noteworthy part is that this software is free to get started and you can access all the features with the free plan.
Hence, without taking any more of your time, let’s get started with the blog about how to add new Workiom records to Google Sheets as rows.
Step 1: Sign up to Pabbly Connect
Let’s begin the process to add new Workiom records to Google Sheets as rows 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 “Workiom to Google Sheets”, you can obviously name the workflow as per your requirements and needs. After naming your workflow, you have to select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, create your free account now. Now, you have to select the application that you want to integrate. In this case, we are choosing “Workiom” for integration. After selecting the application select “New Record Created” in the choose method section. After selecting the application, now you have to click the “Connect with Workiom” button just like in the above-shown image to take further the integration process. To connect Workiom with Pabbly Connect, you have to paste the API key from your Workiom account to the Pabbly Connect dashboard and then send a test request. For that, you need to login to your Workiom account. Now to get the API key, go to your profile section and then select “My Profile”. Scroll down and copy the given API key from your Workiom account. Next, paste the copied API key in the Pabbly Connect dashboard and click the “Save” button. After connecting the Workiom account with Pabbly Connect, now you have to map the required fields like app ID, list ID, etc. These details can be found easily in your Workiom account. Once you have filled in the details, hit the “Save & Send Test Request” button. Here, we can see that these two services are integrated and now we will capture the data from your Workiom account. To capture the data, click on the “Capture Webhook Response” button. To check if the integration is capturing data or not, we will add a new record in your Workiom account. Now to add a new record, open your list and then click on the “+Record” button. Next, add the record details like name, email, etc, and hit the “Save & Close” button. As soon as you click on the “Save & Close” in Workiom and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option. To make this Workiom-Google Sheets integration work, you have to choose the action for your trigger. Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “Google Sheets” to integrate and in the method section select “Add New Row”. After choosing the application click on the “Connect with Google Sheets” button to move forward. To connect Google Sheets to Pabbly Connect, you have to authorize the application. For this, you have to log in to your Google account. Next, to authorize Google Sheets, you need to again click on the “Connect with Google Sheets” button and then select the Google account through which you wish to log in. After connecting with your Google account, map all the fields quickly like name, email, etc by clicking on the map button given at the side of every field. Once you are done adding up all field data click on the “Save & Send Test Request” button. Here, you can see that integration was successful and the new record from Workiom is updated in the Google Sheets automatically. Now, whenever there will be any new records created in Workiom, it will be automatically added to your Google Sheets. Finally, now you know how to add new Workiom records to Google Sheets as rows. This is a one-time process, now all your manual work will be done by the online business automation and integration tool i.e Pabbly Connect. Just follow this step by step procedure mentioned above and your Workiom to Google Sheets integration is all set. So, what’s stopping you now! Go and catch your deal by signing up for a free account. In case of any queries, please drop your comments below. We will try to reach you as soon as possible.Step 2: Access Pabbly Connect
Step 3: Workflow for Workiom to Google Sheets Integration
(a) Create New Workflow
(b) Name the Workflow
Step 4: Setting Triggers for Workiom to Google Sheets Integration
(a) Select Application you want to Integrate
(b) Click Connect Button
Step 5: Connecting Workiom to Pabbly Connect
(a) Go to My Profile
(b) Copy the API Key
(c) Paste the API Key
(d) Map the Fields
(e) Send Test Request
(f) Save the API Response
Step 6: Add a Record
(a) Click Record Button
(b) Add Record Details
Step 7: Test the Submission in Pabbly Connect Dashboard
Step 8: Setting Action for Workiom to Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
Step 9: Connecting Google Sheets to Pabbly Connect
(a) Click on Connect Button
(b) Map the Fields
(c) Send Test Request
Step 10: Check Response in Google Sheets
Conclusion –
You May Also Like to Read –