Learn business growth with Google Analytics 4 Forums Google Analytics 4 Automating button clicks in Google Sheets for Analytics v4 Reports Reply To: Automating button clicks in Google Sheets for Analytics v4 Reports

  • Jordan

    Member
    18 June 2023 at 12:59 am

    Unfortunately, Google Apps Script cannot directly simulate a button click on a Google Sheet. The actions triggered by click events on an interface can only be reproduced by calling the function directly associated with that button’s click event. The clickable images or buttons implemented by SyncWith are likely using their own proprietary function upon a click event which makes it almost impossible to reproduce from a standalone Google Apps script. However, you can consider reaching out to the SyncWith support, they might provide you with a Public API or a way to automate this workflow.