Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

How do I make macros integrate with Google Sheets?

Can I refer to cells in a google sheets dog, when I make a macro in roll20? If so, how?

We have a very well functioning google sheets character sheet we use, and have no desire to change over to the integrated roll20 character sheets, but as the macro-guy in our group, I would love to be able to refer to our character sheet in google sheets, so that it would be more easily made to auto-update whenever we level up, find loot or whatever.
May 02 (7 years ago)
The Aaron
Pro
API Scripter
That simply isn't possible.  Macros can only refer to content in the Roll20 Data Model, they can't refer to something on another website.
May 02 (7 years ago)
keithcurtis
Forum Champion
Marketplace Creator
API Scripter
Some sheets have an import script that can create a character from structured data. But it would require A) making an export function on your Google Sheet, and B) Becoming a Pro member in order to use API scripts. Assuming of course, you choose or write a sheet/script with this capability. And of course, it would not be a live link to the data, merely an export/import.
Ah bummer. It would be so efficient though, but alas, I am no where near good enough at scripting, to make my own API unfortunately. Thanks for the answers
May 13 (7 years ago)
GiGs
Pro
Sheet Author
API Scripter
For importing purposes, you dont need to be a scripter. You do need to be a Pro user , and be willing to switch to a roll20 character sheet. Which you aren't, but I mention it just in case you change your mind in the future.

There's a script called ChatSetAttr, which can set attributes.

So, you can add a sheet on your google sheet, that builds an output string, which you then copy and paste into roll20 chat, and will fill a character sheet correctly.

It takes a little work to set up the first time (but its not hard, it's just a laborious process of matching the cells in your sheet to roll20 sheet attribute names), but once it's done one, it will work for all your characters with a couple of clicks.


May 13 (7 years ago)
keithcurtis
Forum Champion
Marketplace Creator
API Scripter
I have a google sheet that builds subclass features for the Shaped Sheet, and one that does the same for Racial features. For obvious reasons, they are only filled out with SRD info, but are easily expandable. And they absolutely require ChatSetAttr.