Microreact
  • Introduction
  • Introductory Videos
  • About Microreact
    • Privacy and Terms Of Service
    • Open source software used by Microreact
    • Change Log
  • Instructions
    • Navigating the site
      • Managing Projects
    • Navigating within a project
      • History sidebar
      • Selection sidebar
      • Views Sidebar
    • Creating a Project
      • Supported File Formats
      • Metadata Data
      • Tree Data
      • Map Data
      • Timeline Data
      • Network Data
      • Matrix Data
    • Adding and Editing Panels
      • Data Table
      • Map
      • Timeline
      • Tree
      • Network
      • Data-slicer
      • Chart overview
        • Area Chart
        • Line Chart
        • Bar Chart
        • Circle, Tick, Point Charts
        • Custom charts
        • Pie Chart
        • Multi-variable Chart
        • Heatmap
      • Note Panel
      • Matrix
    • Selecting and Filtering Data
    • Labels, Colours, and Shapes
    • Saving and version control
    • Access Control and Project Sharing
      • Download Project Files
      • URL control options
    • Tips & FAQ
      • How to Link Microreact projects to Google Sheets
  • API
    • API Access Tokens
    • Creating Projects via API
    • Updating Projects via API
    • Deleting Projects via API
    • Sharing Projects via API
    • Migrating to the new API
  • Feedback
    • Contact the Microreact team
Powered by GitBook
On this page
  • I. Configure Google Sheets Access Settings
  • II. Configure Google Sheets Publish Settings
  • III. Create Microreact project

Was this helpful?

  1. Instructions
  2. Tips & FAQ

How to Link Microreact projects to Google Sheets

PreviousTips & FAQNextAPI Access Tokens

Last updated 2 years ago

Was this helpful?

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. Upload the data file to Google Sheets or open an existing Google Sheets file.

  2. Click on the Share button in the top right corner to change share settings.

  3. Click on on Get shareable link.

  4. Make sure that option Anyone with the link can view is selected.

  5. Finally click on Done button.

II. Configure Google Sheets Publish Settings

  1. Select File menu.

  2. Click on Publish to the web....

    \

  3. Choose Comma-separated values (.csv).

    \

  4. Click on Published content and settings.

    \

  5. Make sure that the option Automatically republish when changes are made is active.

    \

  6. Click on Publish button.

  7. Finally, copy the shareable link generated by Google Sheets.

III. Create Microreact project

  1. Click on the green plus button in the bottom right corner, then select Add URLs

  2. Paste the shareable link under Enter URL.

  3. Select Data (CSV) under File kind

  4. Add more files (e.g. a Newick tree file) or click CONTINUE to created the project.

Goto

https://microreact.org/upload
Google Sheets
Google Sheets
Google Sheets
Google Sheets
Google Sheets
Google Sheets share button
Google Sheets
Google Sheets
Google Sheets
Google Sheets