Connect Mailchimp with Google Sheets/Excel Online or Smartsheet using webMethods.io Integration

Connect Mailchimp with Google Sheets/Excel Online or Smartsheet using webMethods.io Integration

Overview

Set up a seamless integration with webMethods.io Integration that captures new subscriber details as rows in your chosen spreadsheet platform.

Prerequisite:

Start with the trigger action

Login to your webMethods.io Integration 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 can be a great introduction.

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

Mailchimp trigger

Mailchimp trigger configuration

Select Subscribe list as a trigger and complete the authorization – connect 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

Fill out subscribers details

Go back to the webMethods.io Integration workflow and click Test. You should see the output data from the trigger which 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

Click on the small settings icon on the Google Sheets connector, select Add row as action and complete the authorization – connect webMethods.io Integration with your Google account (check the following Tutorial - Using Google services with webMethods.io Integration).

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

Now go back to the 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

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

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

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

Now go back to the 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

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

Click on the small settings icon on the Smartsheet connector, select Add Rows as action and complete the authorization – connect webMethods.io Integration with your Smartsheet account.

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

Now go back to the 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

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

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

Now you’ve seen how easy is to build an integration with 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

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

Execution status

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

Workflow settings button

Workflow settings

Read more

Read full topic