I am thinking of integrating google sheets and wondering if anyone has had experience using with Miro. I see that Zapier does automate certain processes (I have yet to fully experiment). Has anyone used google sheets or excel with Miro with any success?
Best answer by Robert JohnsonView original
To get my Google Sheet embedded into a board, I
Here’s what the sheet looks like in the board (I added the logo):
To edit the sheet, you can double-click it (or single-click and select the pencil edit icon) and it opens as such for real-time editing:
As for Excel/One Drive, I tried these same steps, but when I click upload > OneDrive from within my board, a blank window opens. I have no idea why, but I don’t foresee myself using Excel online anytime soon, so I’ll troubleshoot later should that time come.
I installed the Google Drive App, yet it does not show up in my Toolbar. Also not available in search any longer.
@jtk & @Robert Johnson
Did anyone ever get excel to do the same as google sheets via share point, I cant get the pencil icon on excel to edit….my workplace do not approve google sheets :(
Both Google Sheets (Google Drive) and Excel online (OneDrive) work the same - you need your Google or M365 admin to authorize the Miro/RealtimeBoard app to access your account.
You could always just put a link to your Google Drive or OneDrive document on the board, the same as you would link to any other external resource. Note, however, if you want anyone from outside of your Google or Microsoft account to be able to view or edit the document, you (or your account admin) will need to configure this on your end.
Example: I would just put this Google Sheet link on the Miro board, rather than trying to connect the Google Drive or OneDrive app:
This is great...Thanks for the response
I’ve followed all the correct steps to embed a doc from google drive on my Miro Board
and that all works fine. However, I can’t edit the document - I’ve clicked the pen and this is what I get
But I can’t edit it. If I click on the Learn More link it just takes me to the site which tells me to uninstall and reinstall google drive etc just as I’ve done above!
I’ve got a number of Miro accounts paid and unpaid and the same thing happens on all of them so what am I doing wrong?
I really, really need to be able to do this for a presentation - otherwise my boss is going to insist on using another platform and it’s taken me long enough to learn this one!
Any help gratefully received.
The Google Drive integration doesn’t actually put the Google Drive files into the Miro board. Instead, think of them as a thumbnail link to Google Drive. When you click on the thumbnail on the Miro board, a modal window/popup opens and displays the document in Google Drive. Once this modal window opens, you are now in Google Drive and cannot use any Miro objects/tools, e.g., Pen.
However, you will be able to use the Pen tool (and other objects) on the Google Drive document thumbnail:
Here is what opening and editing the above Google Document looks like from a Miro board:
If you are still unable to edit a document using the Google Drive integration, a workaround would be to just paste a link to the Google Drive document on the board, just like you would like to any other website/resource.
OK, I understand now that you can’t edit in Miro itself, however even when I open up the doc whether by pasting the link or by embedding the page I still can’t do anything with the page that opens unlike your ‘test word for miro doc’ mine doesn’t allow me to add or change anything.
What do I need to do to make this work?
For other files types, you will need to go to Google Drive and see what options you have to convert them to a Google Document.
Example → https://www.luminpdf.com/blog/the-best-ways-to-edit-pdf-in-google-docs-for-2020/
Here’s what you should in order to edit a Google Drive doc from a Miro board: