Create a formatted timestamp to the full name of the day and month.Formats here: https://developers.google.com/sheets/api/guides/formats
The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Connect your published Google Site to Google Sheets with Apps Script and a Button. Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.
Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Build a fully functioning AI powered startup pitch generator in 20 minutes. I saw a tweet listing startup accelerators and thought it would be cool to build a tool that edits my own startup idea into a personalized pitch to each startup accelerator fund. Get it for your google drive down belowhttps://docs.google.com/spreadsheets/d/1KevSvdwpONP89eBOe-8fDfp2fGlBafE7BAtI5wgGe2UGet the AI script here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni
Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
See where to find errors in your apps script and how to fix them. You will either get syntax errors ( the way the code is written) or runtime errors (when you actually run the code).
Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.Final code is available in the sheet below. And the original template code is available here:https://bettersheets.co/snippets/updated-open-ai-model-to-omni