Google Sheets News & Updates for December 2024

Google Sheets Expands Row Limit to 100,000 for Looker Integration

15 days ago

Google has raised the row limit for Connected Sheets for Looker pivot tables to 100,000, allowing for analysis of larger datasets in Google Sheets. This update is available to all Google Workspace customers, including individual and personal users. The integration supports over 60 databases, enabling users to combine Looker data with Sheets data and analyze large datasets directly. Users need access to their Looker instance URL to connect.

Trending ️‍🔥

Meta enhances Instant Forms with Google Sheets integration for automated lead collection

16 days ago

Google Sheets Meta Ads

Meta has updated its Instant Forms feature to allow direct integration with Google Sheets for automated lead data collection, eliminating the need for third-party services like Zapier. The setup is simple through Business Manager, requiring access to 'Instant Forms', selecting 'CRM setup', and authenticating with Google. This integration automatically populates lead information in Google Sheets, enhancing data management and lead management efficiency.

Google Sheets Integrates BigQuery Saved Queries

1 months ago

Google Sheets BigQuery

Google now allows users to search and use pre-defined BigQuery queries directly within Google Sheets Connected Sheets, improving data analysis efficiency. Access saved queries via Connection Settings, Edit connection, Saved queries and query editor, and Project-based search. The feature is rolling out to all domains, expected to complete by December 6, 2024, and is available to Google Workspace customers, Workspace Individual Subscribers, and personal users.

Third-party Smart Chips Now Available in Google Sheets

1 months ago

Google Sheets

Google Sheets now supports third-party smart chips, allowing users to pull data from apps like Asana, Jira, Canva, and more. Users can paste third-party chips from Docs into Sheets. To use this feature, install the relevant add-on from the Google Workspace Marketplace and paste a link from the third-party source into your spreadsheet. The rollout begins on October 8, 2024, for Rapid Release domains and October 28, 2024, for Scheduled Release domains.

Top-Notch Google Ads Audit Tool

Featured

Effortlessly audit your Google Ads account with Marketing Auditor. Perform 200+ automated checks to uncover optimization opportunities and save over 10 hours per audit. Generate white-label reports in minutes with 50+ pages of actionable insights. Customize your reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides. This tool is the ultimate solution for efficient and impactful Google Ads audits.

Google Sheets Adds New Table Features for Easier Data Management and Integration

2 months ago

Google Sheets

Google has introduced new features in Google Sheets to enhance data management and integration. Users can now insert blank tables directly from the sidebar, use the IMPORTRANGE function to reference tables across sheets, and utilize keyboard shortcuts for quick range-to-table conversions. These updates streamline data organization, improve cross-sheet referencing, and speed up table creation, making Sheets more efficient and user-friendly.

Google Introduces URL Allowlist and Audit Logs for Apps Script and Sheets

4 months ago

Google Apps Script Google Sheets

Google is introducing a feature allowing admins to restrict URLs accessed by Apps Scripts and Sheets. Admins can monitor accessed URLs via new logs and create an allowlist to control access, aligning with Zero Trust security. This impacts admins and end users, addressing data exfiltration concerns. Logs are found under Reporting and Security sections, and allowlists in the Admin console. Rollout starts July 31, 2024.

Trending ️‍🔥

Google Sheets Gets Major Updates: 2x Faster, AI Sidebar, New Tables, Custom Alerts

5 months ago

Google Sheets

Google Sheets has announced major updates, including doubling calculation speed on Chrome and Edge browsers, thanks to WasmGC technology. New features include a side panel in Gemini for Workspace to help organize data, pre-built tables for easy data management, and improved formatting with new tables features. Additionally, custom alerts can now be set for specific changes in data, enhancing project management and collaboration capabilities.

Trending ️‍🔥

How to Create a Looker Studio report from Google Sheets

6 months ago

Google Sheets Looker Studio

Looker Studio announced direct integrations with Google Sheets, allowing users to create reports directly from Sheets. Reports not saved will be deleted after 24 hours. To create a report, navigate to the desired Google Sheet, use the Extensions menu to create a new report, and save it. Options include using the first row as headers, including hidden cells, and defining cell ranges. Ensure data is in tabular format, unmerged, and properly typed.

Trending ️‍🔥

Google Sheets Launches Conditional Notifications for Email Alerts on Specific Changes

6 months ago

Google Sheets

New Google Sheets feature, Conditional Notifications, allows users to set email alerts for specific changes in spreadsheets. Users can create rules to notify them or others when criteria like cell value changes are met. This feature aims to enhance workflow visibility and team communication. Available for Google Workspace Business Standard, Plus, Enterprise Starter, Standard, Plus, Education Plus, and Enterprise Essentials.

Google Sheets News

FAQs

What are the top Google Sheets updates I must know about in 2024?

What are the latest Google Sheets news this month?

What are the best Google Sheets tools that I should use?

What's the best source for Google Sheets news and updates?

Is there a Google Sheets newsletter I can subscribe to?