Connect Mailchimp with Google Sheets/Excel Online or Smartsheet using webMethods.io Integration
Tags: integration, mailchimp, excel, webmethods
Published: 2024-03-13 13:01:29

---
title: Connect Mailchimp with Google Sheets/Excel Online or Smartsheet using webMethods.io Integration
published: true
date: 2024-02-22 10:16:31 UTC
tags: integration, mailchimp, excel, webMethods
canonical_url: https://tech.forums.softwareag.com/t/connect-mailchimp-with-google-sheets-excel-online-or-smartsheet-using-webmethods-io-integration/291939
---

 

## Overview

Set up a seamless integration with [webMethods.io](http://webMethods.io) Integration that captures new subscriber details as rows in your chosen spreadsheet platform.

### Prerequisite:

- [webMethods.io Integration](http://webmethods.io/) tenant – [sign up here](https://signup.softwareag.cloud/#/basic?product=webmethodsioint) for a free trial if you’re new (use the [advanced form](https://signup.softwareag.cloud/#/advanced?product=webmethodsioint) for more options).
- MailChimp account
- Google account/Excel Online account/Smartsheet account

## Start with the trigger action

Login to your [webMethods.io Integration](https://www.softwareag.cloud/site/product/webmethods-io-integration.html) tenant, create a new project, or choose an existing one. 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.

Click on the small setting icon on the Start step and choose the MailChimp trigger.

[![Mailchimp trigger](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/f/bfb228e1e321a4cbc2ed9e239e52ec5fa6bc9945_2_310x220.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/f/bfb228e1e321a4cbc2ed9e239e52ec5fa6bc9945.png "Mailchimp trigger")

[![Mailchimp trigger configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/a/5/a533c259f26add1809c83bde95a60251d7045f66_2_310x221.png)](https://global.discourse-cdn.com/techcommunity/original/3X/a/5/a533c259f26add1809c83bde95a60251d7045f66.png "Mailchimp trigger configuration")

Select _Subscribe list_ as a trigger and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your MailChimp account. Select a subscribers list 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. Open your MailChimp instance and subscribe a contact to the list:

[![Add a Mailchimp subscriber](https://global.discourse-cdn.com/techcommunity/optimized/3X/c/1/c162a2556866332181eeb9ca134cc711a331ab1b_2_552x184.png)](https://global.discourse-cdn.com/techcommunity/original/3X/c/1/c162a2556866332181eeb9ca134cc711a331ab1b.png "Add a Mailchimp subscriber")

[![Fill out subscribers details](https://global.discourse-cdn.com/techcommunity/optimized/3X/8/5/85065f641b13546dbd7b66e6f4d6ec5220333781_2_488x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/8/5/85065f641b13546dbd7b66e6f4d6ec5220333781.png "Fill out subscribers details")

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**.

## Configure the spreadsheet connectors

Choose one of the following ways to store your subscribers’ details:

### Google Sheets

Search for the Google Sheets connector and add it to the canvas with the drag and drop feature. This automatically connects with the trigger action.

![Connect Google Sheets connector with the trigger action](https://global.discourse-cdn.com/techcommunity/original/3X/b/2/b2cf6e4d8d7866584afca7b851bb677ec46891b7.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)).

[![Google Sheets add row action](https://global.discourse-cdn.com/techcommunity/optimized/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208_2_352x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208.png "Google Sheets add row action")

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 subscribers:

[![Google Sheets spreadsheet](https://global.discourse-cdn.com/techcommunity/optimized/3X/4/8/4868f45c5130a3ce863031253188e065ff9b9551_2_315x399.png)](https://global.discourse-cdn.com/techcommunity/original/3X/4/8/4868f45c5130a3ce863031253188e065ff9b9551.png "Google Sheets spreadsheet")

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 contact information for each table column:

[![Google Sheets connector configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/7/5/759db5077cf4f8abe5260c2ddb6042e119d6f615_2_690x343.png)](https://global.discourse-cdn.com/techcommunity/original/3X/7/5/759db5077cf4f8abe5260c2ddb6042e119d6f615.png "Google Sheets connector configuration")

Click **Next, Test** and then **Done.**

### Excel Online

Add the Excel Online connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.

![Connect Excel Online connector with the trigger action](https://global.discourse-cdn.com/techcommunity/original/3X/4/8/48437d8fa6896f2fd9bb2e41d32c17e7e940630c.png)

Click on the small settings icon on the Excel online connector, select _ **Add Rows** _ as action and complete the authorization – authorize Excel Online.

[![Excel Online add rows action](https://global.discourse-cdn.com/techcommunity/optimized/3X/f/0/f000f8c9333af20fce4687aad5b73d639b028085_2_343x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/f/0/f000f8c9333af20fce4687aad5b73d639b028085.png "Excel Online add rows action")

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:

[![Excel Online spreadsheet](https://global.discourse-cdn.com/techcommunity/optimized/3X/e/b/ebed12d0b3b81e2cb2b68094aeb367bb69a5763a_2_228x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/e/b/ebed12d0b3b81e2cb2b68094aeb367bb69a5763a.png "Excel Online spreadsheet")

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 contact information for each table column:

[![Excel Online connector configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/0/10366fa760271795f70881530a0452bf149030b1_2_690x342.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/0/10366fa760271795f70881530a0452bf149030b1.png "Excel Online connector configuration")

Click **Next, Test** and then **Done.**

### Smartsheet

Add the Smartsheet connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.

![Connect Smartsheet connector with the trigger action](https://global.discourse-cdn.com/techcommunity/original/3X/5/f/5f03b48722510845b9e63d147956fcbbefdfa5d3.png)

Click on the small settings icon on the Smartsheet connector, select _ **Add Rows** _ as action and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Smartsheet account.

[![Smartsheet add rows action](https://global.discourse-cdn.com/techcommunity/optimized/3X/d/e/de4efd010207ce97a317eada95472d936b9ad22d_2_349x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/d/e/de4efd010207ce97a317eada95472d936b9ad22d.png "Smartsheet add rows action")

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:

[![Smartsheet spreadsheet](https://global.discourse-cdn.com/techcommunity/optimized/3X/d/a/da6b20016d28d881922ffd831eb19d72c47140de_2_552x282.png)](https://global.discourse-cdn.com/techcommunity/original/3X/d/a/da6b20016d28d881922ffd831eb19d72c47140de.png "Smartsheet spreadsheet")

Now go back to the [webMethods.io](http://webMethods.io) Integration action configuration and choose the sheet ID. Use the Incoming data panel and the drag and drop feature to fill out the values for each table column:

[![Smartsheet connector configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/d/6/d6d140ec015c4105f0154e613f86f101adbd63c8_2_690x347.png)](https://global.discourse-cdn.com/techcommunity/original/3X/d/6/d6d140ec015c4105f0154e613f86f101adbd63c8.png "Smartsheet connector configuration")

Click **Next, Test** and then **Done.**

Once you are done with the spreadsheet connector configuration, connect it to the _Stop_ step and save your workflow:

[![The final workflow](https://global.discourse-cdn.com/techcommunity/optimized/3X/f/4/f4c59de4b69b3171c8ea2569cf409df3535de554_2_690x311.png)](https://global.discourse-cdn.com/techcommunity/original/3X/f/4/f4c59de4b69b3171c8ea2569cf409df3535de554.png "The final workflow")

## Test the workflow

It’s time to test your workflow - run it 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 rows added to your Google Sheets/Excel Online or Smartsheet sheet. Please note that this may take some time.

[![Smartsheet spreadsheet](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/3/23cee17125cf289bc0a4e45994490159d3f290b7_2_552x182.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/3/23cee17125cf289bc0a4e45994490159d3f290b7.png "Smartsheet spreadsheet")

Now you’ve seen how easy is to build an integration with [webMethods.io](http://webMethods.io) Integration that will extract and store your data.

## Execution history

At the bottom-left corner of your workflow screen you can find the Execution history of the workflow:

[![Execution history](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/4/244c660c8e6e9e2e636fd9b99e25f2f39c59ba23_2_690x123.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/4/244c660c8e6e9e2e636fd9b99e25f2f39c59ba23.png "Execution history")

From here you can monitor the execution status and view error details if needed:

[![Execution status](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/5/159e3befbf7d701971aed490ced4fbf4eb208890_2_690x156.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/5/159e3befbf7d701971aed490ced4fbf4eb208890.png "Execution status")

Please note that workflow execution logs must be enabled from the workflow execution settings:

![Workflow settings button](https://global.discourse-cdn.com/techcommunity/original/3X/9/f/9f8f81d1142fbbceb32ac1dd20490f46eba93ef8.png)

[![Workflow settings](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca_2_690x373.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca.png "Workflow settings")

## Read more

- [Integrate Mailchimp with Pipedrive using webMethods.io Integration](https://tech.forums.softwareag.com/t/integrate-mailchimp-with-pipedrive-using-webmethods-io-integration/290805)
- [Create Google Calendar events from Google Sheets with webMethods.io Integration](https://tech.forums.softwareag.com/t/create-google-calendar-events-from-google-sheets-with-webmethods-io-integration/291548)
- [webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online](https://tech.forums.softwareag.com/t/webmethods-io-integration-workflow-store-typeform-entry-data-in-google-sheets-or-excel-online/289772)


[Read full topic](https://tech.forums.softwareag.com/t/connect-mailchimp-with-google-sheets-excel-online-or-smartsheet-using-webmethods-io-integration/291939)