Microreact
Search…
⌃K

How to Link Microreact projects to Google Sheets

This tutorial shows how to create a Microreact project linked to data on Google Sheets. It also shows how to configure Google Sheets to automatically publish changes to the linked Microreact project. In order for Microreact to download the CSV file, you need to follow this guide to generate a download link for the CSV file of Google Sheets.

I. Configure Google Sheets Access Settings

  1. 1.
    Upload the data file to Google Sheets or open an existing Google Sheets file.
  2. 2.
    Click on the Share button in the top right corner to change share settings.
    Google Sheets share button
  3. 3.
    Click on on Get shareable link.
    Google Sheets
  4. 4.
    Make sure that option Anyone with the link can view is selected.
    Google Sheets
  5. 5.
    Finally click on Done button.

II. Configure Google Sheets Publish Settings

  1. 1.
    Select File menu.
  2. 2.
    Click on Publish to the web....
    Google Sheets
    \
  3. 3.
    Choose Comma-separated values (.csv).
    Google Sheets
    \
  4. 4.
    Click on Published content and settings.
    Google Sheets
    \
  5. 5.
    Make sure that the option Automatically republish when changes are made is active.
    Google Sheets
    \
  6. 6.
    Click on Publish button.
  7. 7.
    Finally, copy the shareable link generated by Google Sheets.
    Google Sheets

III. Create Microreact project

  1. 2.
    Click on the green plus button in the bottom right corner, then select Add URLs
    Google Sheets
  2. 3.
    Paste the shareable link under Enter URL.
    Google Sheets
  3. 4.
    Select Data (CSV) under File kind
  4. 5.
    Add more files (e.g. a Newick tree file) or click CONTINUE to created the project.