Install the Google Sheets – FTP quickstart integration template

Contents

• Overview: Understanding the Google Sheets - FTP quickstart integration template
•  Install the Google Sheets - FTP quickstart integration template
  • Before you install
    • A. Create your Celigo iPaaS account
    • B. Gather your credentials
  • Install the Google Sheets - FTP quickstart integration template
  • Set up the connections and integrate with FTP
    • Connect to Google Sheets
    • Connect to FTP
  • Get started with the quickstart template
• Configure and run flows in the Google Sheets - FTP quickstart integration template

You can install the Google Sheets – FTP Quickstart template from the integrator.io Marketplace (US | EU).

Before you install

A. Create your Celigo iPaaS account

Sign up for an integrator.io account with administrative access.

B. Gather your credentials

Keep your Google Sheets and FTP account credentials ready:

• FTP – verify APIs and Authorization
  • Before you set up an FTP connection below, ensure that you have the API and authentication details for your FTP.
  • Refer to your specific FTP help documentation to learn more about APIs and Authorization.
• Google Sheets – verify APIs and Authorization
  • Before you set up a Google Sheets connection below, ensure that you have the API and authentication details for Google Sheets.
  • Refer to the Google Sheets help documentation to learn more about APIs and Authentication.

Install the Google Sheets – FTP template

1. From the Google Sheets marketplace select the FTP template and click Preview.

2. Review the template’s contents and ReadMe file and click Install now to begin.

Set up the connections and integrate with FTP

Next, you’re presented with setup options for Google Sheets and FTP.

Step 1: Connect to FTP

Click Configure to establish the FTP connection using either FTP, SFTP, or FTPS configurations. If you previously set up a connection to FTP, select it from the list. Otherwise, click Set up new connection and provide your FTP account credentials.

Click Save & close to test the connection and return to the template installation.

Step 2: Connect to Google Sheets

Click Configure to establish the Google Sheets connection. If you have already set up a connection to Google Sheets, select it from the list. Otherwise, click Set up new connection and provide your Google Sheets account credentials.

Click Save & close to test the connection and return to the template installation.

Get started with the quickstart template

Now that you’ve installed this quickstart template in your integrator.io account, understand how to configure and run your flows:

• To familiarize yourself with the integration tile, refer to Understand how to use your integration tile.
• To know more about how to schedule or run a flow, refer to Schedule data flows.
• To know how to use the flow-dashboard, refer to Understand your dashboards.
• To understand template management, refer to Delete or restore a quickstart integration template.