Google Sheets integration advice

  • 21 October 2021
  • 1 reply
  • 263 views

Userlevel 1
Badge

I’d like to be able to take Google Sheet cells and create sticky notes in Miro.  I;ve seen it done with a manual cop-and-paste, but I’d like to automate it so I can do it with several Sheet ranges.

I’m wondering if Zapier, the API or some other solution is the way to go.

If the API is the way to go, are there examples of using the Javascript built into Google Sheets?  


1 reply

From here:  https://help.miro.com/hc/en-us/articles/360017572054-Sticky-notes

But it doesn’t explain the API part of your request.

Pasting from a spreadsheet

You can also copy data from any spreadsheet and paste it on the board as a cluster of stickies, where each sticky note represents a single cell.

  1. Copy cells from the spreadsheet using Ctrl + C (for Windows) or Cmd + C (for Mac)
  2. Click the canvas (you do not need to open the bulk mode)
  3. Use Ctrl + V (for Windows) or Cmd + V (for Mac) to paste sticky notes on the board

Each cell will be imported as a sticky note. The maximum number of cells that you can paste at a time is 5000 (but not more than 50 rows and 100 columns); the maximum number of characters is 6000.

⚠️ Please note that this feature is not available in the Internet Explorer browser.

Reply