Skip to main content

Google Drive

Seamlessly sync form data to Google Sheets and Drive

Updated over 3 months ago

Google Drive is a powerful tool for teams needing real-time collaboration on documents, especially spreadsheets. By integrating Google Drive with Array, you can automatically push form responses, files, and PDFs into shared spreadsheets — keeping your team in sync and your data organized without lifting a finger.

In This Guide:

  • What is Google Drive?

  • How to connect your Array account to Google Drive

  • Create a new Google Spreadsheet from a form

  • Automatically send Array form responses to Google Sheets

  • Save files (media, PDFs) to Google Drive

  • Populate an Array form using data from a Google Spreadsheet

  • BONUS: Populate one spreadsheet using data from another

What is Google Drive?

Google Drive is a cloud-based suite of productivity tools from Google. It allows teams to:

  • Create and collaborate on spreadsheets, documents, and presentations

  • Store and share files like images, PDFs, and videos

  • Access everything in real time from anywhere

All Google accounts come with access to Drive.
👉 Create a free Google account here

Connecting Google Drive to Array

  1. Go to the Installed Apps section from your Array dashboard

  2. Search for Google Drive in the Array Market

  3. Click “Connect”

    google_drive

  4. A pop-up window will request permission to access your Google account

  5. Click “Allow” to authorize access

    google_drive2

  6. Your account will now be listed as connected

You can manage or switch accounts by clicking “Add Google Drive Account”

Disconnecting Google Drive

If you need to remove the integration:

  • Go to Installed Apps → Google Drive

  • Click the trash can icon next to your account email

Any forms relying on Google Drive will stop syncing properly after disconnection

Create Google Spreadsheets from Form Submissions

Want every new form response to be saved into a shared spreadsheet?

Here’s how:

  1. Open the desired form in the Form Builder

  2. Click the “Connect” button at the top

  3. Navigate to the “Storage” tab

  4. Select the Google Sheets option

  5. Click the Google Sheet toggle in the Form Attachment Menu

  6. Click Save

Now, each form submission will be sent as a new row to a Google Sheet stored in a Drive folder named “Array”

Save Files to Google Drive from Array

You’re not limited to text and numbers — you can also store:

  • Media files (photos, videos, audio)

  • PDFs of submitted forms

To save files:

  1. In the Form Builder, go to the Connect > Storage > Google Sheets area

  2. Enable the toggle for the type of file(s) you want to save

    • For example, turn on the PDF toggle

  3. When a user uploads or submits these files via the form, a link will be added to the spreadsheet and the file will be stored in Drive

All attachments are linked directly in the spreadsheet for quick access.

Populate a Form Using Google Sheet Data (Data Search)

Need to pre-fill form fields using info from a spreadsheet? Use the Data Search feature:

  1. In the Form Builder, drag a “Data Search” field from the Text Input tab onto your form

  2. Click the field to open the Search Data Link menu

  3. Navigate to the Integrations tab and select Google Drive

  4. Choose the spreadsheet you want to pull data from

  5. Select the columns you want to use as searchable fields

  6. Save your form

Now when users begin typing into the search field, matching entries from the spreadsheet will auto-suggest and populate the form.

Bonus: Populate One Spreadsheet from Another

Want to connect one spreadsheet to another for automatic updates or dynamic data reference?

Watch our Video Tutorial Here (Insert actual video link)

Or contact support for assistance with advanced spreadsheet workflows.

Tips & Best Practices

Tip

Description

Use Google Sheets for reporting

Automatically track real-time form responses

Attach PDFs for audit trails

Include full form responses with media and metadata

Use filters in Zapier

Set conditions for when to send data to specific sheets

Share Google Sheets with your team

Collaborate in real time without emailing files

Keep your Drive organized

Use naming conventions or folders by form name or date

Use Cases

  • Field Teams: Submit reports from the field and auto-store them in Drive

  • Appointment Forms: Automatically record bookings in a Google Sheet

  • Inspections: Save completed inspection forms with images and PDFs

  • Lead Capture: Store leads from a form directly in a CRM spreadsheet

Did this answer your question?