Apologies I am posting this again due to the old post being closed for inactivity.
I am trying to find a way to post a snapshot of an active google sheet (it gets updated/rewritten every 15 minutes) to a Slack message.
To be more specific I have a data set with headers and I just want to create a list of data from 2 columns and an undetermined amount of rows and have it displayed in a slack post for example:
H1 | H2 |
---|---|
R1 | R1-Detail |
R2 | R2-Detail |
R3 | R3-Detail |
Slack outpost:
R1 R1-Detail
R2 R2-Detail
R3 R3-Detail
I have tried digest but it replicates/duplicates data when I only want a snapshot at the specific time. Any other ideas? Possibly something with loops but how do I get the data fields when the trigger is a schedule?