Google Forms

⌘K
  2. Home
  4. Docs
  6. Google Forms
  8. Step 2: Set up Data Desti...
  10. Option 6: Set up File FTP as Data Destination for Google Forms

Option 6: Set up File FTP as Data Destination for Google Forms

Video Walkthrough

Description  

The File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server over a computer network. FTP works on a client-server model, using separate control and data connections for smooth and secure file transfers.


Prerequisites  

Before you begin, make sure you have:

  • FTP Server Address (Hostname)
  • FTP Server Port (default: 22 for SFTP, 21 for FTP, 990 for FTPS)
  • FTP Server Username
  • FTP Server Password

Getting Started  

  • From the left navigation panel, go to Destinations → Files.
  • Click on the File FTP connector tile.

Select Source  

  • Select Google Forms as the source type.

Choose Connection Name  

  • Select the Google Forms connection name you want to integrate.
  • Provide a name for this connection (this name will also be used in your FTP folder structure).

Configure File Transfer Settings  

  • Choose File Transfer Mode: Supported options are SFTP, FTP, or FTPS.
  • Select Data Export Frequency: Options include Real-time, 1 hour, 3 hours, or 1 day.
  • Click Next.

Provide FTP Access Credentials  

Fill in the required credentials:

  • Hostname: FTP server address.
  • Port: FTP port number (default 22 for SFTP).
  • Username: FTP account username (must have read/write access).
  • Password: FTP account password.
  • Relative Path to Data Folder: The folder path where files should be stored (if left blank, files will be placed in the root directory).
  • Click Next.

Folder & File Organization  

  • A folder named Datahash will be created automatically inside the relative path you provided.
  • Inside the Datahash folder, a subfolder named after your Google Forms connection will be created.
  • Data files will be stored in this subfolder, with filenames including a timestamp for version tracking.
  • This structure ensures your files remain well-organized and easy to access.

Verify & Finish  

  • Once credentials are validated, click Finish to complete the setup.
  • You can now see the connected instance on the dashboard.

Managing Connections  

Adding a New Instance  

  • Start the setup again by selecting Google Forms as the source.
  • Enter FTP credentials and file transfer preferences.
  • Click Next → Finish.
  • The new connection (e.g., Ads connection 2) will appear in the Manage Existing Connections table.

Editing an Existing Instance  

  • Go to the Manage Existing Connections table.
  • Click on the connection name you want to update.
  • Click the Edit icon (top-right corner).
  • Update the desired values (e.g., credentials, path, frequency).
  • Click Next, then Finish to apply updates.
    • If you click Cancel, the previous configuration will remain active

How can we help?