Live Forms v7.2 is no longer supported. Click here for information about upgrading to our latest GA Release.

Skip to end of metadata
Go to start of metadata

Form designers must obtain a Google access token for every Google account you wish to use with your forms/flows. For example if you connect your forms/flows to a Google account and, you will need to obtain two access tokens.

Follow these steps to use the frevvo Google connector consent UI to obtain an access token for each Google Account.

  1. Open your web browser and login to your Google Account

  2. Go to:

    1. Live Forms Online Cloud customers:

    2. Live Forms In-house customers: http://<your frevvo server domain name>/google/consent
  3. Click Allow if you see the message below: This gives frevvo access to your account even when your device is turned off.

  4. Copy the access token. THIS IS VERY IMPORTANT. The token is used as the password for frevvo wizards and rules.

  5. Repeat steps 1-2 for all Google accounts you will be using with the frevvo Google connector.

    An access token generated for a frevvo in-house installation running the Google connector, will not work with the Google connector running in the frevvo cloud. You must generate a separate token for each environment.

It is very important to save the token once you obtain it for a given account. The token allows the connector to access the account. There is a limit on the number of tokens that are issued per client-user combination. If the token limit is exceeded, older refresh tokens stop working.  A token can be revoked if it is not used in a 6 month period.

Google Sheet Best Practice

Create a new user in your Google domain and make that user the owner of all the Google sheets that integrate with your forms/flows. This is recommended for the following reasons:

  1. It will eliminate confusion when searching for the correct sheet that integrates with your forms/flows.
  2. When you use the Google Wizards it will show all sheets that are available for integration in the dropdown.
  3. Reduces the chance of another user changing a column or worksheet tab name which could break integration with your forms/flows.
  • No labels