Automatically Publish Data from a Connected Sheet
AnsweredHi there. We have a spreadsheet that is auto-populated via a chain ("Overwrite Sheet" command) multiple times per day. We then publish the contents of the sheet to other users as a connected sheet. This requires us to hit the "REPUBLISH" icon each time the data on the sheet is refreshed by the chain command (See screenshot below of the icon - highlighted in yellow).
Is there a way to set this up so that each time the sheet is updated from the chain command that the sheet is then republished automatically, so we don't have to keep hitting this button?
There is a chain command called "Publish Spreadsheet" but this doesn't seem to work. Thanks for any help.
-
Hi Bradley, Data Sets cannot be republished via the Spreadsheet API. Alternatively, a Chain could pull the data from BALANCE_SHEET and then overwrite other sheets with that data. Or cells could be linked to propagate data where needed.
The Publish Spreadsheet command is used to publish links.
0Please sign in to leave a comment.
Comments
1 comment