How to pull data from google sheets
I have got a report that is created from a google form via the data being entered into a google sheet. When a response is submitted, the data is recorded on the sheet and the pdf report is created and automatically emailed back to the responder. I have some columns in a second page of the sheet with formulas created from the data on the first page, and the markers in this column are not populating the pdf report (they are being populated from the markers on the first page of the sheet). However, when I go to the Document Studio side bar, it recognises all the markers in the document and shows all the correct data in the preview of the report. How come it’s not firing correctly into the pdf report that is being emailed back to the responder? Thanks if you can help!