How to import data from a JSON file stored on Google Drive?

You can use JSON importer to load a JSON file from Google Drive. However, a shareable link generated by Google Drive by default will not work in this case - you need to modify it as described below:

  1. Make your file available for anyone in the View mode:Step1_share_file.gif
  2. Modify the copied link as follows:

2.1 Copy file id from the original link: 1d50TTxmqlTNyS61iihSlrGLT4GsmhphU

2.2 Paste your file id to this template https://drive.google.com/u/0/uc?id={{file_id}}&export=download (instead of {{file_id}}), so the new link looks as follows - https://drive.google.com/u/0/uc?id=1d50TTxmqlTNyS61iihSlrGLT4GsmhphU&export=download

You can use our Helper to generate a link to import JSON from Google Drive.

Paste your modified link to the JSON importer:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.