Thanks for replying sir,
Yes, the select event type was “On Open”. Now I have changed it to “On Edit”.
I have noticed that when I make a change on WordPress, the Google Sheet is updated immediately, whereas if I make a change from Google Sheet, there is no change in WordPress.
And now this notice is also showing on the Google Sheet page:
“Oopss! It looks like REST API access is blocked on your website. The REST API access is needed to connect to the Google Sheets. Please enable the REST API access. Click here to learn more about this error and the solutions”
