Ready to Download and Run

by arcesb | December 22, 2017

Synchronize Data from Excel to Google Sheets

Automatically synchronize your Microsoft Excel spreadsheets to Google Sheets with this easy-to-use workflow.

Download Flow

The Synchronize Data from Excel to Google Sheets sample flow has pre-configured connectors for transforming Excel files into XML that are ready to be sent to Google Sheets. The following connectors make up the core elements of the flow:

  • Excel Connector: Uses scripting templates to generate Excel sheets out of XML files, or XML files from Excel sheets.
  • Cloud Data Connector: Interfaces with a wide range of cloud application data sources provided the corresponding CData driver is installed. This allows you to insert data to or retrieve it from Google Sheets.
    Note: If you have not already, you will need to install the CData ADO.NET/JDBC Driver for Google Sheets. You can download a free, 30-day trial. If you just downloaded and installed the driver, please restart ArcESB before proceeding.

These connectors are configured to automatically move files from one connector to the next until the data from Excel has been synchronized with Google Sheets.

You can modify the automation settings for each connector in its Automation tab, or you can manually process each step in the workflow using the Send button in the connector's Input tab. You can schedule the application to poll Excel for new data from the Excel Connector's Automation tab, or you can manually receive data by using the Receive button from its Output tab.

If you would like to use this sample flow in your workspace, please follow these instructions:

Importing Workspace

Create Workspace

First, navigate to the Flows tab and click on the cogwheel icon in the top right corner. Choose the Create Workspace option to create a new Workspace for this sample flow.

Import Workspace

Then, from the same cogwheel dropdown, click Import Workspace. In the resulting dialog, choose the downloaded sample flow excelgooglesync.arcflow to import the relevant connectors and settings. You can choose to import the flow into any Workspace you like, but we recommend using separate Workspaces for distinct workflows.

Once you have successfully imported the sample flow, you can begin configuring the connectors to best suit your specific use case.

Excel Connector

Set Up Excel Template

Navigate to the Settings tab of the Excel Connector. Configure a template file that defines how to transform the Excel into XML; as an example, the pre-configured connector contains a simple template that transforms an Orders file into XML.

Cloud Data Connector - Google Sheets

Connect to Google Sheets

Navigate to the Settings tab of the Cloud Data Connector. In order to establish a connection with Google Sheets, you must click the Connect button, which will take you to the Google login page. Enter your account credentials and authorize Google Sheets to securely share your data with ArcESB.

Once you configure the these connectors, the sample flow is ready for use!

Synchronize Data from Excel to Google Sheets

Are You Up & Running?

If the answer is yes, congratulations for successfully configuring the Synchronize Data from Excel to Google Sheets sample flow! However, if you are confronted by any issues or have any further questions, please do not hesitate to contact us.