webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online
Tags: integration, typeform, google, excel
Published: 2024-04-11 11:56:32

---
title: webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online
published: true
date: 2024-01-11 12:50:39 UTC
tags: integration, Typeform, google, excel
canonical_url: https://tech.forums.softwareag.com/t/webmethods-io-integration-workflow-store-typeform-entry-data-in-google-sheets-or-excel-online/289772
---

 

## Overview

This guide will walk you through the process of building a [webMethods.io](http://webMethods.io) Integration workflow that stores your Typeform form entries in Google Sheets or Excel Online sheet and notifies you through Cisco Webex Teams.

### Prerequisites:

- Typeform account
- Excel online or Google Sheets account
- Cisco Webex Teams account

## Steps

1. Login to your [webMethods.io Integration](https://www.softwareag.cloud/site/product/webmethods-io-integration.html) tenant or [sign up](https://signup.softwareag.cloud/#/basic?product=webmethodsioint) for a free trial if you’re new (use the [advanced sign up form](https://signup.softwareag.cloud/#/advanced?product=webmethodsioint) for more options).
2. Create a new project or choose an existing one.
3. Go ahead and get started by creating a blank workflow. If you need a refresher on how to get to this point, this [guide](https://docs.webmethods.io/integration/workflow_building_blocks/creating_first_workflow/#gsc.tab=0) can be a great introduction.
4. Click on the small setting icon on the Start step and choose the Typeform trigger.
[![chrome_ygDZQcGxBJ](https://global.discourse-cdn.com/techcommunity/optimized/3X/7/c/7ccc221def62e4f44ea7a3a78018c740fd72375a_2_310x217.png)](https://global.discourse-cdn.com/techcommunity/original/3X/7/c/7ccc221def62e4f44ea7a3a78018c740fd72375a.png "chrome\_ygDZQcGxBJ")
[![chrome_7lGelfQCl4](https://global.discourse-cdn.com/techcommunity/optimized/3X/5/c/5c085603d7156460f503430f8e667c45b0e12e07_2_310x220.png)](https://global.discourse-cdn.com/techcommunity/original/3X/5/c/5c085603d7156460f503430f8e667c45b0e12e07.png "chrome\_7lGelfQCl4")
Select _New entry_ as a trigger and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Typeform account. Select a form ID from the dropdown menu.
Click **Save**. You should see the test trigger window.
To test your trigger, you need to perform the trigger action – submit your Typeform form:
[![chrome_gQmIC0Npcj](https://global.discourse-cdn.com/techcommunity/optimized/3X/c/f/cfe9af0872af7fefad6eef5c1fd16852b6cbaccc_2_552x249.jpeg)](https://global.discourse-cdn.com/techcommunity/original/3X/c/f/cfe9af0872af7fefad6eef5c1fd16852b6cbaccc.jpeg "chrome\_gQmIC0Npcj")
Go back to the [webMethods.io](http://webMethods.io) Integration workflow and click **Test**. You should see the output data from the trigger which [webMethods.io](http://webMethods.io) Integration will use to configure and test the rest of the workflow. Click **Done**.
1. Choose one the following ways to store the form submissions’ details:
5.1. Add the Google Sheet connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.
![chrome_DaFlN5uBnI](https://global.discourse-cdn.com/techcommunity/original/3X/d/1/d10c8a2ecff930ad26efc66fec70868f74bb5fe9.png)
Click on the small settings icon on the Google Sheets connector, select _ **Add row** _ as action and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Google account (check the following [Tutorial - Using Google services with webMethods.io Integration](https://tech.forums.softwareag.com/t/tutorial-using-google-services-with-webmethods-io-integration/237307)).
[![chrome_PlGrw8HBXr](https://global.discourse-cdn.com/techcommunity/optimized/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208_2_330x375.png)](https://global.discourse-cdn.com/techcommunity/original/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208.png "chrome\_PlGrw8HBXr")
Click **Next**.
Before you can proceed with the action configuration, you need to make sure you have already created a sheet containing several columns where you will store information about your form’s submissions:
[![chrome_nnTHdBx4S0](https://global.discourse-cdn.com/techcommunity/optimized/3X/c/1/c136771f3c9d82bc32e85b5468bab9a1237c208b_2_517x298.png)](https://global.discourse-cdn.com/techcommunity/original/3X/c/1/c136771f3c9d82bc32e85b5468bab9a1237c208b.png "chrome\_nnTHdBx4S0")
Now go back to the [webMethods.io](http://webMethods.io) Integration action configuration and choose the spreadsheet ID and the sheet name. Use the Incoming data panel and the drag and drop feature to fill out the form information for each table column:
[![chrome_9R8qvMUHJd](https://global.discourse-cdn.com/techcommunity/optimized/3X/e/7/e78378547b1838e28314d9a53ea6ebaee8ceda81_2_517x250.png)](https://global.discourse-cdn.com/techcommunity/original/3X/e/7/e78378547b1838e28314d9a53ea6ebaee8ceda81.png "chrome\_9R8qvMUHJd")
You can use the Transform Data option to extract the form response:
[![chrome_TSM1ws9Y1o](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/1/b12b4456daaa4dd16292ef79a35f8031a0a40885_2_517x250.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/1/b12b4456daaa4dd16292ef79a35f8031a0a40885.png "chrome\_TSM1ws9Y1o")
and then turn the object result into string with one more transform data action:
[![chrome_ljhFOpDGx8](https://global.discourse-cdn.com/techcommunity/optimized/3X/8/0/80339f8cb29da3e8f6d07a6dd02053c1ba97cc7d_2_517x270.png)](https://global.discourse-cdn.com/techcommunity/original/3X/8/0/80339f8cb29da3e8f6d07a6dd02053c1ba97cc7d.png "chrome\_ljhFOpDGx8")
Click **Next, Test** and then **Done.**
5.2. Add the Excel online connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.
![chrome_FdcPSKeiKl](https://global.discourse-cdn.com/techcommunity/original/3X/6/a/6af2a3fc843ccf9c73e6665a945030ff243e06bd.png)
Click on the small settings icon on the Excel online connector, select _ **Add Rows** _ as action and complete the authorization – authorize Excel Online.
[![chrome_sfNTNEK9V7](https://global.discourse-cdn.com/techcommunity/optimized/3X/f/0/f000f8c9333af20fce4687aad5b73d639b028085_2_321x375.png)](https://global.discourse-cdn.com/techcommunity/original/3X/f/0/f000f8c9333af20fce4687aad5b73d639b028085.png "chrome\_sfNTNEK9V7")
Click **Next**.
Before you can proceed with the action configuration, you need once again to make sure you have already created a sheet containing several columns:
[![chrome_XEIgluhTc9](https://global.discourse-cdn.com/techcommunity/optimized/3X/6/5/65ecee5c0462abd1ca50522f26ed101237a4b38d_2_360x375.png)](https://global.discourse-cdn.com/techcommunity/original/3X/6/5/65ecee5c0462abd1ca50522f26ed101237a4b38d.png "chrome\_XEIgluhTc9")
Now go back to the [webMethods.io](http://webMethods.io) Integration action configuration and choose the folder name, workbook ID and sheet ID of your file. Select _Single Row Entry_ as entry type and use the Incoming data panel and the drag and drop feature to fill out the form information for each table column:
[![chrome_2FLmkdZeEV](https://global.discourse-cdn.com/techcommunity/optimized/3X/f/3/f3ed9ac5b12f92e8348ac52e81b87a5bdc859bb0_2_517x258.png)](https://global.discourse-cdn.com/techcommunity/original/3X/f/3/f3ed9ac5b12f92e8348ac52e81b87a5bdc859bb0.png "chrome\_2FLmkdZeEV")
You can use the Transform Data option to extract the form response:
[![chrome_TSM1ws9Y1o](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/1/b12b4456daaa4dd16292ef79a35f8031a0a40885_2_517x250.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/1/b12b4456daaa4dd16292ef79a35f8031a0a40885.png "chrome\_TSM1ws9Y1o")
and then turn the object result into string with one more transform data action:
[![chrome_ljhFOpDGx8](https://global.discourse-cdn.com/techcommunity/optimized/3X/8/0/80339f8cb29da3e8f6d07a6dd02053c1ba97cc7d_2_517x270.png)](https://global.discourse-cdn.com/techcommunity/original/3X/8/0/80339f8cb29da3e8f6d07a6dd02053c1ba97cc7d.png "chrome\_ljhFOpDGx8")
Click **Next, Test** and then **Done.**
1. Add the Cisco Webex Teams connector to the canvas with the drag and drop feature. This automatically connects with the previous step.
![chrome_T2u6sYWSiZ](https://global.discourse-cdn.com/techcommunity/original/3X/8/0/809acb94aafc46dee7572f0bd873e0544e952fec.png)
[![chrome_jjOKSkwEQd](https://global.discourse-cdn.com/techcommunity/optimized/3X/8/3/833cfe7f66bb61b98a180d236c01acdc249619a7_2_448x193.png)](https://global.discourse-cdn.com/techcommunity/original/3X/8/3/833cfe7f66bb61b98a180d236c01acdc249619a7.png "chrome\_jjOKSkwEQd")
Click on the small settings icon on the Cisco Webex Teams connector, select _ **Post new message** _ as action and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Cisco Webex Teams account.
[![chrome_umq0Fwbbqc](https://global.discourse-cdn.com/techcommunity/optimized/3X/7/b/7bc71a1c0eafca9eb46c5ac2df4f793f745d96da_2_328x375.png)](https://global.discourse-cdn.com/techcommunity/original/3X/7/b/7bc71a1c0eafca9eb46c5ac2df4f793f745d96da.png "chrome\_umq0Fwbbqc")
Now you can proceed with the action configuration – choose the _Space ID_ where you want to post the message. Type the message body – use the Incoming data panel to include form information received from the trigger output, for example:
```
{{$trigger.title}} form is submitted at {{$trigger.submitted_at}}. 
Check the form response:
{{$transform.t3.stringifiedObject}}

```
[![chrome_mbZWuC7jBR](https://global.discourse-cdn.com/techcommunity/optimized/3X/0/e/0e6a2e72763e8e3e5bb9bd2f2e993b5474c4b0a1_2_552x273.png)](https://global.discourse-cdn.com/techcommunity/original/3X/0/e/0e6a2e72763e8e3e5bb9bd2f2e993b5474c4b0a1.png "chrome\_mbZWuC7jBR")
Click **Next** and then **Done**.
7. Connect the Cisco Webex Teams connector to the Stop step. Don’t forget to save your workflow.
[![chrome_6AhmjGmqvU](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/d/2d48944e19e761d73e22a909047c442870b9d1e7_2_690x315.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/d/2d48944e19e761d73e22a909047c442870b9d1e7.png "chrome\_6AhmjGmqvU")
You can now run the workflow using the play button in the right upper corner and review the result. If you have configured the workflow correctly, you should see the newly created row added to your Google Sheets or Excel Online as well as a notification sent to your Cisco Webex Teams space:
[![chrome_lXjc8xsdBb](https://global.discourse-cdn.com/techcommunity/optimized/3X/a/a/aa29eb5fac08c2549dd7c1442f3ffe6446afa04c_2_517x236.png)](https://global.discourse-cdn.com/techcommunity/original/3X/a/a/aa29eb5fac08c2549dd7c1442f3ffe6446afa04c.png "chrome\_lXjc8xsdBb")
[![chrome_w0hoEAlnoG](https://global.discourse-cdn.com/techcommunity/optimized/3X/6/5/656525025bf49b5f22f75cdfcfbd123fc2e43468_2_517x184.png)](https://global.discourse-cdn.com/techcommunity/original/3X/6/5/656525025bf49b5f22f75cdfcfbd123fc2e43468.png "chrome\_w0hoEAlnoG")
[![chrome_1uV3f6qs1S](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/a/2acf0161eb0eeeeb16454523c18194ccb72ed674_2_517x103.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/a/2acf0161eb0eeeeb16454523c18194ccb72ed674.png "chrome\_1uV3f6qs1S")
Now every time your Typeform form is submitted, a new row will be added to your Google Sheets or Excel Online and notification will be sent to Cisco Webex Teams. Please note that this may take some time.
1. At the bottom-left corner of the screen you can find the Execution history of the workflow:
[![chrome_bOyQX0tbFU](https://global.discourse-cdn.com/techcommunity/optimized/3X/7/8/7828c031ff25a5f17a3d8f9e6de02d6db20d412b_2_690x115.png)](https://global.discourse-cdn.com/techcommunity/original/3X/7/8/7828c031ff25a5f17a3d8f9e6de02d6db20d412b.png "chrome\_bOyQX0tbFU")
From here you can monitor the execution status and view error details if needed:
[![chrome_veZTL0Otid](https://global.discourse-cdn.com/techcommunity/optimized/3X/e/0/e0ec4b19e9104f6f58188e4b7a738a476254f1b3_2_690x146.png)](https://global.discourse-cdn.com/techcommunity/original/3X/e/0/e0ec4b19e9104f6f58188e4b7a738a476254f1b3.png "chrome\_veZTL0Otid")
Please note that workflow execution logs must be enabled from the workflow execution settings:
![chrome_A3Qr403vVw](https://global.discourse-cdn.com/techcommunity/original/3X/9/f/9f8f81d1142fbbceb32ac1dd20490f46eba93ef8.png)
[![chrome_AXIAS0wjIO](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca_2_517x279.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca.png "chrome\_AXIAS0wjIO")

[Read full topic](https://tech.forums.softwareag.com/t/webmethods-io-integration-workflow-store-typeform-entry-data-in-google-sheets-or-excel-online/289772)