Documentation - RestApp

Google Drive

Google Drive gives secure access to all of your content such as Google Sheets and file type (.json, .txt, .csv, .xls, .xlsx). Store, share, and collaborate on files and folders with any teammates.

GoogleDrive can be used as an input and/or an output.

File type supported

  • GoogleSheet
  • JSON
  • TXT
  • CSV
  • XLSX
  • XLS

Syncing mode

  • Add data (Insert)
  • Erase and replace data (Drop)

Setup

To configure GoogleDrive connector (the user needs to have access to the target directory and file with write privileges):

  1. Give a name to your connector:
    Gdrive - Name

  2. Click on Authenticate with Google:
    Gdrive - Authenticate button

  3. Allow RestApp and its features:
    google

  4. Test the connection and be sure it is successfull:
    Gdrive - Authentication success

Refresh Token

Click on Remove Access https://myaccount.google.com/permissions to refresh token.
Gdrive - Refresh token

Follow the Setup part from 2 for the next step.

Info

The following file types don't support Object and Array format:

  • TXT
  • CSV
  • XLSX
  • XLS