If you check the How do I FAQ for Construct 2 to the section AJAX, you will find examples of how to save data on a distant server.
I'm not sure you can do it with google sheets, although perhaps you could their API if it is available but it also means that your sheet could be edited by anyone which is not very safe, and with RGPD's law, you are responsible for the list of email address you gather.
A distant server/database sounds like something you could have more secured.
Otherwise, you can use local storage and save the data on the device where the game is executed, but it means you can't "trust" those informations and make global leaderboards for a competition.
You can find examples of use of Local Storage in the FAQ as well.