Create a new Google Sheet → just visit this link → sheets.new
[OPTIONAL] Give that sheet any name so that it looks good, like → My Phone Activity
Write Time and Activity in the first row like this 👇
On Toolbar → Extensions → Apps Script
Remove the code which is written there
Copy the code below and paste it there
- Code (click on > icon to expand)
Credit goes to: https://github.com/jamiewilson/form-to-google-sheets
Click on Save
Click on Run
Click Review permissions
Choose your Gmail account in which you created this Google Sheet.
Click Advanced
Click ‘Go to Untitled project (unsafe)’ Don’t worry. It’s just asking to trust your own app as it isn’t verified lol. I think you can trust yourself 😂 or no? 💀
Click Continue. It’s just asking for permission to edit your Google Sheet. Obviously we’ll need that permission as we’re going to write our phone activity on that sheet.
Then you should see 'Execution completed’ message.
Now click on Deploy → New deployment
Click on Settings icon → Web app
