https://community.qlik.com/t5/Qlik-Automate/Automation-to-Google-sheet/m-p/1945845#M651 <P>How can I include totals in qlik automation to google sheet</P> Mon, 20 Jun 2022 15:36:30 GMT GuruGPS 2022-06-20T15:36:30Z https://community.qlik.com/t5/Qlik-Automate/Automation-to-Google-sheet/m-p/1945845#M651 <P>How can I include totals in qlik automation to google sheet</P> Mon, 20 Jun 2022 15:36:30 GMT https://community.qlik.com/t5/Qlik-Automate/Automation-to-Google-sheet/m-p/1945845#M651 GuruGPS 2022-06-20T15:36:30Z https://community.qlik.com/t5/Qlik-Automate/Automation-to-Google-sheet/m-p/1946205#M655 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/152366">@GuruGPS</a>&nbsp;,</P> <P>You could use the blocks <STRONG>Get Measure Value</STRONG> or <STRONG>Get Expression Value</STRONG>&nbsp;from the Qlik Cloud Services connector to get the Totals for every field. Then you can use the output from any of those blocks in the <STRONG>Append One Row To Sheet</STRONG> block from the Google Sheets connector.</P> <P>Emile</P> Tue, 21 Jun 2022 11:28:53 GMT https://community.qlik.com/t5/Qlik-Automate/Automation-to-Google-sheet/m-p/1946205#M655 Emile_Koslowski 2022-06-21T11:28:53Z