Tag Archives: Editors

Easily refresh Salesforce data in Sheets

What’s changing 

You now have the option to refresh the Salesforce data populated in Sheets using the Salesforce data connector. You can refresh this data manually or schedule the data to be refreshed.

Currently, the Salesforce data connector for Sheets gets data from reports or imports when the sidebar is opened and has been configured. In order to get updated data, users would need to go through the same configuration steps in the sidebar.

Who’s impacted 

End Users

Why you’d use it 

If you use Salesforce to track important conversations with key leads, you can make sure this data is consistently fresh by scheduling a refresh rather than reimporting the Salesforce data.

If your Sales team uses the add-on to import details of their accounts from Salesforce into Sheets, they can schedule this data to refresh daily or even multiple times a day to stay on top of the current data.

How to get started 

Admins: No action needed.
End users: Here’s how to refresh your Salesforce Data in Sheets:

  1. Open the Data connector from Salesforce Add-On and select Refresh. 
  2. Select Manual Refresh to refresh the current data on your sheet or Auto Refresh to schedule a refresh every 4, 8, or 24 hours. 
  3. Review your selections and select Create. 

Helpful links 

Availability 

Rollout details 
G Suite editions 
  • Available to all G Suite Editions.

On/off by default? 
  • This feature will be ON by default.
Stay up to date with G Suite launches

Manage workflows and automate processes with the new Google Docs API

What's changing

With the new Docs API, there are more ways to build services that better support your business and improve your workflows. For documents that require consistency, collaboration, and accuracy — like invoices, proposals, contracts, and reports — the API will help automate common word processing tasks with the real-time editing and collaboration of Docs.

Who’s impacted 

Developers 

Why you’d use it 

Some ways you could use this API are: 
  • Create documents automatically 
    •  Use the Docs API to automate document creation, like creating all of the blank invoices you need for a particular quarter with a single click. Documents that require a template, like legal documents or contracts, can be automated based on user input and monitored with the API as well. 
  • Manage workflows 
    • Use the Docs API to add user or system-provided data to a document at various stages of a process. Programmatic edits to the same document over time, or to multiple documents at once, can simplify your workflows. 
  • Sync with your content management systems 
    •  From internal wikis to blog content, you can import and export document details seamlessly between Google Docs your employees are editing and your content management systems. For example, publishing platforms can now allow their customers to compose and collaborate in Docs to drive content to their sites. 

How to get started 

For more information and how to get started, see the Docs API developer site. 

Additional details 


The Docs API will round out a complete set of APIs across all G Suite editor applications along with the Sheets API and the Slides API. 


Helpful links 

Availability 

G Suite editions 
Available immediately to all G Suite editions. 

On/off by default? 
The API is available and accessible by default to all G Suite users.

Stay up to date with G Suite launches

Refresh BigQuery data in Sheets using Apps Script and Macros

What's changing

Recently we launched the BigQuery data connector to allow users to easily import data from larger datasets into Sheets. Now, you can use tools like Apps Script and the macro recorder to schedule automatic updates within Sheets to the connected BigQuery data.

Who’s impacted 

End Users

Why you’d use it 

Stay on top of the latest and greatest data critical to your business by automatically refreshing the BigQuery data in your sheet.

For example, you can set sales data to automatically refresh so that it’s ready for analysis at the beginning of each day. You can also auto-update data in preparation for key meetings or presentations that occur on a weekly or monthly basis. Or you could set a trigger to auto-update your data each time you open the spreadsheet.

How to get started 

  • Admins: No action required. 
  • End users: Here’s how to schedule a refresh on the data pulled in by the BigQuery data connector: 
    1. Record a macro to refresh your data 
      •  On your computer, open a spreadsheet that contains data connected to BigQuery in Google Sheets. 
      • Record a macro from a different tab then the one you want to refresh. 
      • After you start recording, switch to the tab you want to refresh. 
      • At the bottom left, click Refresh. 
      • Click Save.
    2. Schedule your macro 
      •  At the top, click Tools > Script editor. 
      • At the top, click Edit > Current project’s triggers. 
      • At the bottom right, click Add trigger and select your options. 
      • Click Save. 

Additional details 

For key permissions for the BigQuery data connector see here.
As always, use sharing permissions to control who can view, edit or share your data.

Helpful links 

Availability 

  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 5, 2019. 
  • Scheduled Release domains: Full Rollout (1-3 days for feature visibility) starting on February 19, 2019. 
G Suite editions 
  • Available to G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and Drive Enterprise. 
  • Not available to G Suite Basic and G Suite for Nonprofits 

On/off by default? 
  • This feature will be ON by default.

Stay up to date with G Suite launches

Additional Thai fonts available in Docs, Sheets, and Slides

Quick launch summary

We’ve expanded our font offerings for Thai users in Docs, Sheets, and Slides by adding several fonts that are part of the Thai “National Fonts” collection. This collection of fonts has been distributed and used by the Government of Thailand as public and official fonts since 2007. We updated the collection so that it could be part of Google Fonts in 2019.

The complete list of new fonts is below:
  • Bai Jamjuree 
  • Chakra Petch 
  • Charm 
  • Charmonman 
  • Fah Kwang 
  • K2D 
  • KoHo 
  • Kodchasan 
  • Krub 
  • Mali 
  • Niramit 
  • Sarabun 
  • Srisakdi 
These updated fonts are now available in Google Docs, Sheets, and Slides with modern OpenType technology, expanded weights and more harmonious designs between Latin and Thai scripts.

These fonts will be made default in the drop down menu for users who have their Google language preference set as Thai.

G Suite editions
Available to all G Suite Editions.
    Stay up to date with G Suite launches

    More language options available for the 2019 Calendar Template in Sheets

    Quick launch summary 

    We’ve expanded language options for creating a 2019 Calendar Template in Sheets. The new language options available are:

    • Brazilian Portuguese 
    • Chinese 
    • Danish 
    • Dutch 
    • Filipino 
    • French 
    • German 
    • Hindi 
    • Indonesian 
    • Italian 
    • Japanese 
    • Korean 
    • Latin American Spanish 
    • Polish 
    • Russian 
    • Spanish 
    • Swedish 
    • Thai 
    • Turkish 
    • Vietnamese 
    Note: The template was previously released in English languages.

    Availability 

    Rollout details 
    G Suite editions 
    • Available to all G Suite editions. 
    On/off by default? 
    • This feature will be ON by default. 

    Material Design for Google Docs, Sheets, Slides, and Sites on Web

    What’s changing

    Google Docs, Sheets, Slides, and Sites will be getting a new look and feel on the web. While there are no functionality changes, users will notice some visual improvements, including:

    • Interface typography that uses Google’s custom-designed and highly-legible typefaces
    • Controls (like buttons, dialogs, and sidebars) that are updated and consistent
    • Iconography that is legible and crisp, with a fresh feel

    The four products in this update join other G Suite products like Gmail and Calendar in sharing a common design language.

    Before

    After


    Who’s impacted

    End users

    Why you’d use it

    This style change is part of a new, consistent design approach from Google. You can expect to see similar changes across other G Suite applications in the future.

    How to get started 


    • Admins: No action needed
    • End users: You’ll see the new look coming your way.


    Availability

    Rollout details

    • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on January 15, 2019
    • Scheduled Release domains: Full rollout (1-3 days for feature visibility) starting on February 11, 2019


    G Suite editions
    Available to G Suite Basic, G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and G Suite for Nonprofits

    On/off by default?
    This feature will be ON by default.

    Stay up to date with G Suite launches
    Notice the new format for these launch announcements? Give us feedback on it here.

    Embed Google+ search streams in new Google Sites

    What’s changing 

    You can now embed a stream of posts from a Google+ search in the new Google Sites. This search could contain simple keywords or advanced search operators.

    This builds on our previous launch, which helped you embed community pages, profiles, and other Google+ streams in new Sites.

    Who’s impacted 

    End users

    Why you’d use it 

    When you embed a stream from G+, users will see the exact same content, whether they’re viewing it on plus.google.com or within an embedded module in a Sites page. They’ll also be able to interact with the content, and have that interaction show in both locations. This can help you create more engaging sites with dynamic and collaborative content from Google+.

    By embedding a stream from a Google+ search, you could embed posts from specific people, or you can embed a Google+ stream that aggregates posts from multiple G+ communities. Users will be able to see the content and interact with it if they choose.

    How to get started 




    Helpful links 

    Help Center: Add Google files, video & more to Google Sites 

    Availability 

    Rollout details 
    G Suite editions 
    Available to all G Suite editions
    On/off by default? 
    This feature will be ON by default
    Stay up to date with G Suite launches

    Notice the new format for these launch announcements? Give us feedback on it here. 

    Analyze hefty data sets with BigQuery and Google Sheets

    What’s changing 

    We’re connecting Sheets and BigQuery to make it easier to analyze and share data. The Big Query data connector will help you:

    • Collaborate with partners, analysts or other stakeholders in a familiar spreadsheet interface
    • Ensure a single source of truth for data without having to create additional CSV exports
    • Streamline reporting and dashboarding workflows


    Who’s impacted 

    End users

    Why you’d use it 

    We built BigQuery to help analysts make sense of large datasets—now it’s easier for employees and team members outside of data analyst functions to access and analyze data. By bringing these two tools together, collaborators and other stakeholders can view up to 10,000 rows of data from BigQuery in an easy, familiar interface. This makes collaboration and insight sharing easier, enabling faster decision making.

    How to get started Admins: 


    To check key permissions for the BigQuery data connector see here.

    Additional details 

    Anyone you share the spreadsheet with will see the data contained in the sheet. Only those with edit access in Sheets and view access to the BigQuery table have the ability to refresh the dataset.

    For key permissions for the BigQuery data connector see here.
    As always, use share permissions to control who can view, edit or share your data.

    In the coming weeks, you’ll be able to use tools like Apps Script and the macro recorder to schedule automatic updates within Sheets to the connected BigQuery data. For example, you can automatically refresh sales data in your spreadsheet so the data is fresh and ready for analysis at the beginning of the day. To learn more about how to record or run macros in Sheets, check out this G Suite Pro Tip. 

    Helpful links Help Center: 

    Analyze BigQuery Data within Sheets 

    Availability

    Rollout Details
    • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 15, 2019. 
    • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 29 2019. 
    G Suite editions 
    • Available to G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and Drive Enterprise. 
    • Not available to G Suite Basic and G Suite for Nonprofits. 
    On/off by default? 
    • This feature will be ON by default.
    Stay up to date with G Suite launches
    Notice the new format for these launch announcements? Give us feedback on it here. 

    Share files more easily with non-Google accounts in Drive Beta

    Soon, people without Google accounts will be able to view, comment, suggest edits to, and directly edit Google Docs, Sheets, and Slides files.

    Organizations often work on documents with external vendors, partners, contractors, and customers. When these partners don't have Google accounts, it is a significant barrier for collaboration.

    We are introducing a beta for an easy pincode identity verification process that will enable G Suite users to invite non-G Suite users to collaborate on files as visitors, using PINs (Personal Identification Numbers). Below is an example of how it works:



    File owners and admins are in full control of sharing 

    File owners can view all the detailed activity on their files and see where it originated, and revoke access from the Drive sharing dialog at any time. Admins can manage all external sharing and audit usage. For more information on sharing settings, check out this Help Center article.

    Apply to join Pincode Sharing in Drive Beta 

    Pincode Sharing in Drive is launching initially in beta. If you're an admin, see more details, review the eligibility requirements, and apply to join the beta.

    Launch Details 
    Editions: 
    Beta is available to all G Suite editions

    Impact: 
    Admins and end users

    Action: 
    Admin action suggested/FYI

    More Information 
    Help Center: Set Drive users' sharing permission
    Join the beta

    Launch release calendar
    Launch detail categories
    Get these product update alerts by email
    Subscribe to the RSS feed of these updates

    More ways to collaborate using Box for G Suite

     We’re making Box for G Suite available for all G Suite customers, bringing Google's rich content creation and editing experiences directly into Box so that companies can stay productive and accelerate their work.

    Admins can enable the integration from within the Box Admin Console.

    Check out this blog post and the Box Community for more information.

    Launch Details

    Editions:
    Available to all G Suite editions

    Rollout pace: 
    Gradual rollout to all Box users through mid-January 2019

    Impact:
    All end users

    Action:
    Admin action suggested/FYI

    More Information 
    Box Community
    G Suite blog post

    Launch release calendar
    Launch detail categories
    Get these product update alerts by email
    Subscribe to the RSS feed of these updates