Pulling data from a chart with AppleScripts & Pages
How can i pull data from a chart with AppleScripts to place into various textboxes in Pages?
In the attached, for instance, I want to extract the dates in line one and plug them into the 6 text boxes on page one. I want to do the same for several other boxes as well using a few other tables of data, but this task would take months of very simple (yet monotonously grueling) work without an automated process involved.
Any help would be great, and I'm even willing to pay for help.
Could I use find and replace? https://iworkautomation.com/pages/body-text-replace.html
Is this an issue that can be solved with Equations? Right now the data is in Google sheets, but I can easily transfer it to Pages or Numbers to get this started. I just have no clue how to begin.
Thanks.
MacBook Air