Excel Integration for Alchemer Workflow

The Excel Integration for Alchemer Workflow is available for purchase as an add-on. If you are interested in purchasing, please contact us for more information.

With the Alchemer Excel integration you can easily: 

  • Push workflow data from Alchemer into a Excel Worksheet. 
  • Update an Excel worksheet with data from Alchemer Workflow
  • Get data from Excel for use in Alchemer Workflow 

Adding a Excel Step to your Workflow

1. Create a Workflow in Alchemer and select your initiator. 

For more information on building Workflows in Alchemer refer to the following documentation: 

2. When you are ready to add the Microsoft 365 step to your Workflow, drag the Microsoft 365 step from the Step Library under Connections. 

3. Click the pencil icon to configure your Excel integration step. 

4. Select the action you would like to perform:

Excel | Push data to Excel 

You will need:

  • Your Office 365 login information
  • Fields in this workflow that contain the data you want to use to insert data into your worksheet.

1. Select "Excel | Push Data to Excel" as your action.

2. Click "Next" on the integration overview screen.

3. Authenticate with your Office 365 account. Click add a new account.  



4. Name your new authentication and click "create".



5. In the sign-in window that appears input your Microsoft 365 credentials. Once complete, return to the setup wizard in Alchemer.

After signing in you will need to grant Alchemer (Tray.io) access to Microsoft 365. 

You will need the following permissions: 

6. Please select if the file you would like to use is on OneDrive or SharePoint.

7. Please enter the folder path where your Excel workbook is located.

8. Choose the Excel workbook that you would like to use to insert data into.

9. Choose the Excel worksheet that you would like to use to insert data into.



10.  Choose the Excel table that you would like to use to insert data into.

You will need to create a table in your Excel sheet. You can create this by navigating to insert > Table in Excel. learn more.

11. Select the fields in this workflow that contain the values you want to use to add a new row in Excel.

12. Click "Save" to complete the integration setup

Now what / Where is my data?

All of the information from this integration is now available in this workflow and all surveys in this workflow. You can use them to: 

  • Add Merge Codes to Email or Survey Invite steps. 
  • Use with Logic in the workflow. 
  • Use to personalize the survey in the workflow.


Excel | Update data in Excel 

You will need:

  • Your Office 365 login information
  • Fields in this survey that contain information used to find the Excel row
  • Fields in this workflow used to add data to an existing Excel row

1. Select "Excel | Update data in Excel"

2. Click "Next" on the integration overview screen. 

3. Authenticate with your Office 365 account. Click add a new account.  



4. Name your new authentication and click "create".



5. In the sign-in window that appears input your Microsoft 365 credentials. Once complete, return to the setup wizard in Alchemer.

After signing in you will need to grant Alchemer (Tray.io) access to Microsoft 365. 

You will need the following permissions: 

6. Please select if the file you would like to use is on OneDrive or SharePoint.

7. Please enter the folder path where your Excel workbook is located.

8. Choose the Excel workbook that you would like to use to insert data into.

9. Choose the Excel worksheet that you would like to use to insert data into.



10.  Choose the Excel table that you would like to use to insert data into.

You will need to create a table in your Excel sheet. You can create this by navigating to insert > Table in Excel.

11. Select the fields in this workflow that contain the values you want to use to add a new row in Excel.

12. Choose the fields in this workflow that you would like to use to update a row in your Excel worksheet.

13. Click "Save" to complete the integration setup. 

Now what / Where is my data? 

All of the information from this integration is now available in this workflow and all surveys in this workflow. You can use them to: 

  • Add Merge Codes to Email or Survey Invite steps. 
  • Use with Logic in the workflow. 
  • Use to personalize the survey in the workflow.


Excel | Get data from Excel 

You will need:

  • Your Office 365 login information
  • Fields in this workflow that contain information to use to find the Excel row

1. Select "Excel | Get data from Excel" 2. Click "Next" on the integration overview screen. 3. Authenticate with your Office 365 account. Click add a new account.  



4. Name your new authentication and click "create".



5. In the sign-in window that appears input your Microsoft 365 credentials. Once complete, return to the setup wizard in Alchemer.

After signing in you will need to grant Alchemer (Tray.io) access to Microsoft 365. 

You will need the following permissions: 


6. Please select if the file you would like to use is on OneDrive or SharePoint.

7. Please enter the folder path where your Excel workbook is located.

8. Choose the Excel workbook that you would like to use to insert data into.

9. Choose the Excel worksheet that you would like to use to insert data into.




10.  Choose the Excel table that you would like to use to insert data into.

You will need to create a table in your Excel sheet. You can create this by navigating to insert > Table in Excel. learn more.

11. Select the fields in this workflow that contain the values you want to use to add a new row in Excel.

12. Click "Save" to complete the integration setup. 

Now what / Where is my data? 

All of the information from this integration is now available in this workflow and all surveys in this workflow. You can use them to: 

  • Add Merge Codes to Email or Survey Invite steps. 
  • Use with Logic in the workflow. 
  • Use to personalize the survey in the workflow.

FAQs 

 What permissions do I need within Alchemer to set-up and use the Excel integration?

1. The Integration Manager Permission is required to set-up and use the Excel integration.
2. To check if you have this permission or grant this permission to someone on your team, go to the left-side product navigation and select the Account drop-down, then click on the user management tab.
3.  Then select the Users tab under User Management.
4. Click your username or the username for another member of your team.
5. Scroll down to the Permissions section and check if the Integration Manager box is checked. If you are an admin you can check the box for other members of your team.

 This integration doesn't fit my use cases, or I want to provide feedback to the Alchemer Product Team!

Alchemer is committed to continuously releasing updates and enhancements to our Workflow initiators. If you have specific use cases, questions, or just general feedback, we would love to hear it. Contact us here!


Basic Standard Market Research HR Professional Full Access Reporting
Free Individual Team & Enterprise
Feature Included In