Skip to content
Cambium AppsCambium AppsCambium Apps Help Center

Connecting VLOOKUP to Google Drive

Sign in with Google once so VLOOKUP can find and read your spreadsheets.

Overview

Section titled “Overview”

VLOOKUP needs access to Google Drive to search for your spreadsheets and read them. The first time you create a Google Sheets source, it asks you to sign in with Google.

Steps

Section titled “Steps”

  1. Click Sign In with Google when VLOOKUP prompts you.

    the VLOOKUP prompt with the Sign In with Google button

  2. Continue to Google. VLOOKUP lets you know it’s opening a new page to connect.

    the VLOOKUP notice that a new page will open to connect to Google

  3. Sign in to Google and select every permission. Google asks you to approve access for VLOOKUP for HubSpot. Tick Select all so every requested permission is granted — if you leave any out, VLOOKUP can’t connect your files.

    the Google consent screen with Select all ticked for every VLOOKUP permission

Once you approve, Google sends you back to the VLOOKUP settings to create your source. You can also close that tab, return to HubSpot, reload the VLOOKUP settings, and start creating the source again.

the confirmation that Google is connected, asking you to reload the VLOOKUP settings

Section titled “Related articles”