-
Adjusting your Google Apps Script to stimulate a button click can be a bit complex, especially if the interface has changed. Unfortunately, Google Apps Script doesn’t have the ability to simulate a click on an image or button in Google Sheets directly like it interacts with cells. This is due to the fact that Google Apps Script is a server-side script and can’t interact with the client-side. What could be done, however, is to create a function in the script to refresh your Google Analytics v4 data. You can then set a trigger for this function to run at your desired intervals to simulate the data refresh. It may require changing your approach a bit but should give you the same results as the button click. To do this, you’d likely need to contact SyncWith to request their API they’ve employed in the new setup or ask if they have a script function that can bypass the button click and refresh directly.
