All articles tagged with #google sheets
Google Sheets is rolling out Sheets Canvas, a Gemini-powered feature that turns spreadsheet data into interactive mini-apps via prompts in the Gemini side panel. It requires no coding or formulas, keeps the canvas synced in real time with the source sheet, and lets users customize layout, design, and functionality and share canvases like regular sheets.
Shortcut AI automates up to 90% of repetitive tasks in Excel and Google Sheets, enhancing efficiency and accuracy in data management, financial modeling, and analysis through AI-driven features like error detection, natural language processing, and customizable visualizations, suitable for a wide range of users from professionals to small business owners.
Google Sheets offers a simple solution for web scraping with the IMPORTXML function, making data extraction accessible to a wider audience. Integrating generative AI like ChatGPT into the mix allows for more advanced web scraping tasks without requiring advanced coding skills. While ChatGPT alone struggled to accurately scrape specific data from a webpage, combining it with Google Sheets and IMPORTXML formulas proved to be a highly efficient and effective approach, highlighting the transformative power of integrating different tools and skills to improve productivity.
Duet AI, a paid add-on for Google Workspace Enterprise, has introduced Enhanced Smart Fill for Google Sheets. This feature leverages AI to detect relationships between cell contents and suggests values for remaining cells, reducing manual data entry and organization. It offers functionality such as sentiment classification, text generation, formatting addresses, and more. Users can accept or reject the suggested values. This feature is available to Workspace customers using Duet AI.
Sourcetable, a startup aiming to build "the world's best spreadsheet," has raised $3 million in seed funding to take on the spreadsheet challenge posed by Microsoft Excel and Google Sheets. The company plans to focus on improving integrations, templates, analysis, reporting, and collaboration features. Sourcetable aims to attract professionals in sales, accounting, finance, support, and HR who require access to and manipulation of significant data. The startup is currently in private beta and plans to launch publicly by the end of the year.
Google is rolling out "Help me organize" for Google Sheets, which uses generative AI to suggest and create table templates for complex tracking and organizing tasks. The feature allows users to enter prompts and customize the table as needed. This is a gradual rollout to Trusted Testers in Google's Workspace Labs program. The addition of AI is fitting for Google Sheets, given its occasionally daunting use case.
Google Bard has released two updates, one to improve its ability to handle mathematical tasks, coding questions, and string manipulation, and the other to allow users to export tables generated by Bard directly into Google Sheets. The new technique called "implicit code execution" helps Bard detect computational prompts and run code in the background, making it more accurate in responding to such prompts. These updates make Bard more useful for daily tasks and demonstrate the rapid advancement of AI technology.
Google's experimental chat system, Bard, has expanded its availability and functionality. It now supports three languages and is available in over 180 countries. Bard can be used for programming and generating Google Sheets functions. Users can switch between dark and light themes and have the option to "Google it" for related topics. Additionally, Bard offers a "View other drafts" option that provides varied formats and sources for responses.
Google Docs is rolling out a new feature that allows users to add emoji reactions to comments, increasing collaboration and enabling users to creatively express their opinions about document content. Google Slides now allows users to replace an image using drag-and-drop, while Google Sheets is adding the YouTube Smart Canvas chip, allowing users to add YouTube data directly into a spreadsheet cell. In Meet, Google is adding the ability to watch livestreams in 1080p and attach files to associated Google Calendar events for easier access.
ChatGPT has rolled out its API, which can be used for SEO-related functions like keyword research, local SEO, content, and link building. The API can be accessed through an OpenAI account and can be integrated with Google Sheets using AppsScript. The API has a token limit of 4,096, which translates to around 16,384 characters per interaction for each prompt and response. The API is better for larger projects, while the web interface is better for getting an excellent output. The price for the ChatGPT API is $0.002 per 1,000 tokens.