Tag Archives: docs

Get on the same page: new Google Docs features power team collaboration

Getting people on the same page for a project can be tough. It requires managing a ton of opinions and suggestions. The last thing you should have to worry about is making sure your team is literally working on the same document. That’s why we built our powerful real-time editing tools to help with this—Google Docs, Sheets and Slides—so that teams can work together at the same time, using the most up-to-date version.

Today, we're introducing new updates to better help with "version control," to customize tools for your workflows, and to help teams locate information when they need it.

Track changes, make progress

It can take dozens of edits to make a document just right—especially a legal agreement, project proposal or research paper. These new updates in Docs let you more easily track your team’s changes. Now, your team can:

  1. Name versions of a Doc, Sheet or Slide. Being able to assign custom names to versions of your document is a great way to keep a historical record of your team's progress. It's also helpful for communicating when a document is actually final. You can organize and track your team’s changes in one place under “Version history” (formerly known as “Revision history”) on the web. Select File > Version history > Name current version. For even quicker recall, there’s an option to select “Only show named versions” in Docs, Sheets or Slides.

  2. Preview “clean versions” of Docs to see what your Doc looks like without comments or suggested edits. Select Tools > Review suggested edits > Preview accept all OR Preview reject all.

  3. Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update. Select Tools > Review suggested edits > Accept all OR Reject all.

  4. Suggest changes in a Doc from an Android, iPhone or iPad device. Click the three dots menu in the top right of your Doc screen to suggest edits on-the-go. Turn on the “Suggest changes” toggle and start typing in “suggestion mode.”

  5. Compare documents and review redlines instantly with Litera Change-Pro or Workshare Add-ons in Docs.

preview-accept-changes-docs
Here's a quick way to preview and accept all changes (or reject them) and name versions of your document

Use new templates, add-on time-saving functionality

Teams use templates in Docs and Sheets to save time on formatting. At the same time, developers are building add-ons to customize functionality. We thought, why not bring these two together? That’s why today, we’re introducing new templates with built-in add-ons and the ability to create your own, so your templates not only look good—but they make sure the work gets done.

These templates allow you to customize and deploy tools specific to your organization’s workflows. We’ve launched five examples of this in the general template gallery, like the new Mutual Non-disclosure agreement (NDA) template from LegalZoom and DocuSign. With this template, businesses can quickly create an NDA and collect signatures using the DocuSign Add-on for Docs. Bonus: it also automatically detects the required signature fields on the template, which saves even more time when you request signatures. This is just one of a few new templates—we’ve also worked with Lucidchart, PandaDoc, EasyBib and Supermetrics to help you save time and maximize efficiency throughout your team’s workflows.

In addition, you can also create your very own template with built-in Add-on customized to your company’s workflows. For example, create a Sheets template paired with an add-on to gather internal approvals or an invoice template in Docs (paired with an add-on) that pulls information from your CRM system.

docusign-docs
The new mutual NDA template from LegalZoom and DocuSign lets you collect NDA approvals stat.

Find the information you need, when you need it

Sometimes the hardest part of creating a proposal or client presentation is tracking down the information you need to include in it. Starting today for G Suite Business and Enterprise customers, Google Cloud Search will integrate with Docs and Slides via the Explore feature. Using Machine Intelligence, Cloud Search surfaces relevant information to help you work more efficiently throughout your day.

To get started, open the Explore tab in Docs or Slides and type what you’re looking for. Cloud Search will show you important details from your information across your G Suite apps including Gmail, Drive, Calendar, Sites and more, to help you create top-notch Docs and presentations.

explore-search-docs
Now you can use Google Cloud Search through the explore features in Docs and Slides.

Teams are using Docs to collaborate in creative ways. Check out this post for inspiration, or visit the Docs site to get started.

Source: Google Cloud


8 tips to help you keep up in Google Keep

Google Keep makes organizing information a cinch. You can easily jot down ideas or share to-dos with co-workers. We asked Mario Anima, product manager for Google Keep, to share some of his favorite Keep tips. This is what we learned.

1. Record voice notes.

For recording thoughts on the go, you can record voice memos within Google Keep on your Android or iOS device. Open up the Keep mobile app, click on the microphone icon at the bottom right of your screen and record your message. When you’re done talking, the recording will automatically end and a new screen will pop up with the text of your message and an audio file.


Record GIF

Click on “title” at the top of your audio file and name your note. Your note is automatically synced with the web app, too, so you can access it on your desktop.

2. Transcribe notes from pictures.

Sometimes a picture is worth a thousand words. Using Optical Character Recognition (OCR), Keep can transcribe text from pictures for you, so you don’t have to worry about typing up notes from a meeting or whiteboard session (shameless plug: you can also use Jamboard for that).

Just take a photo, select “Grab Image Text”  and Keep will transcribe your note.

OCR gif

3. Create drawings and even search handwritten notes.

You can sketch images in Keep. Select the pen icon at the bottom of your mobile screen and a bunch of options will appear. Play with colors, shades and more. Once you’re finished with your drawing, you can share it right away with coworkers. Or, you can come back to handwritten memos later by searching for what you wrote.

Speaking of search, you can also find images by searching for words contained within them. Say you snap a photo from a whiteboard and the image contains the word “Proposal.” Just search Keep for “proposal” and your image will appear.

4. Drag and drop notes from Keep into Google Docs.

Now you can use Keep directly within Docs—take notes you’ve created in Keep and drag them into client proposals and more.

If you’re in a Doc: click “Tools” on the menu bar, and then “Keep Notepad.” A sidebar will pop up with all of your note options. You can scroll through the list or use the search bar to jump right to the note you need. Once you’ve found it, drag-and-drop the note into your doc.

If you’re in the Keep app: select the note you want to send, click the three dots menu and click “Copy to Google Doc.”

You can also create notes in the Keep notepad while viewing a Doc. One bonus is that when you create a note in Docs, Keep creates a source backlink—so you can access the note in Keep and it will link back to the source document where the note was created.

Keep GIF

5. Use the Chrome Extension.

Create notes while you browse the web by downloading the Chrome Extension. One cool thing is that when you create a note using the extension, it saves the site URL with it. So if you browse back to that same URL, the extension will show your note in context.

Chrome Extension

6. Send notes from Keep to other apps you use.

Some teams save content from other messaging or social media apps in Keep to reference later. Or, vice versa, you might use Keep to draft emails or social media posts on-the-go. Click on the three dots in the bottom right corner of your Keep app, select “send” and choose the app you want to share your note with.

7. Color-code or label your notes to find them quicker.

To organize your notes by color-coding them in Keep, at the bottom of a Keep note, select the three dots menu and choose from several colors to help you quickly identify a note. You might consider color-coding by task or deadline. If you’re working on your desktop, you can also use the Category Tabs for Google Keep Extension in Chrome to assign category names by color. It will look like this:

Changing colors in Keep

You can also add labels to your notes. Another way to locate your information in Keep is to add and create labels using #hashtags. When you create a note in the Keep app, you can type #label-name and Keep will prompt you to either apply a label if it already exists, or create one if it doesn’t. It’s a pretty handy shortcut.

8. Set reminders for yourself.

Notes matter only if you can execute on what your record. Keep lets you set up reminders which can help.

Select a note and click the finger icon at the top right of your screen in Keep (it has a string on it). When you do that, a pop-up window will give you options to set reminders. The great thing about this is that these reminders will alert you in other Google tools, like Calendar, Chrome or on your Android device.

Note: make sure you have Reminders enabled inside your Calendar app in order to see them. You can check out how to do that on our Help Center under the “Don’t see your Reminder” or “Switch between Tasks and Reminders” section.

Try Keep today

Keep is a great way to keep track of your work tasks. Learn more about how you can get started on our site.

Source: Google Cloud


8 tips to help you keep up in Google Keep

Google Keep makes organizing information a cinch. You can easily jot down ideas or share to-dos with co-workers. We asked Mario Anima, product manager for Google Keep, to share some of his favorite Keep tips. This is what we learned.

1. Record voice notes.

For recording thoughts on the go, you can record voice memos within Google Keep on your Android or iOS device. Open up the Keep mobile app, click on the microphone icon at the bottom right of your screen and record your message. When you’re done talking, the recording will automatically end and a new screen will pop up with the text of your message and an audio file.


Record GIF

Click on “title” at the top of your audio file and name your note. Your note is automatically synced with the web app, too, so you can access it on your desktop.

2. Transcribe notes from pictures.

Sometimes a picture is worth a thousand words. Using Optical Character Recognition (OCR), Keep can transcribe text from pictures for you, so you don’t have to worry about typing up notes from a meeting or whiteboard session (shameless plug: you can also use Jamboard for that).

Just take a photo, select “Grab Image Text”  and Keep will transcribe your note.

OCR gif

3. Create drawings and even search handwritten notes.

You can sketch images in Keep. Select the pen icon at the bottom of your mobile screen and a bunch of options will appear. Play with colors, shades and more. Once you’re finished with your drawing, you can share it right away with coworkers. Or, you can come back to handwritten memos later by searching for what you wrote.

Speaking of search, you can also find images by searching for words contained within them. Say you snap a photo from a whiteboard and the image contains the word “Proposal.” Just search Keep for “proposal” and your image will appear.

4. Drag and drop notes from Keep into Google Docs.

Now you can use Keep directly within Docs—take notes you’ve created in Keep and drag them into client proposals and more.

If you’re in a Doc: click “Tools” on the menu bar, and then “Keep Notepad.” A sidebar will pop up with all of your note options. You can scroll through the list or use the search bar to jump right to the note you need. Once you’ve found it, drag-and-drop the note into your doc.

If you’re in the Keep app: select the note you want to send, click the three dots menu and click “Copy to Google Doc.”

You can also create notes in the Keep notepad while viewing a Doc. One bonus is that when you create a note in Docs, Keep creates a source backlink—so you can access the note in Keep and it will link back to the source document where the note was created.

Keep GIF

5. Use the Chrome Extension.

Create notes while you browse the web by downloading the Chrome Extension. One cool thing is that when you create a note using the extension, it saves the site URL with it. So if you browse back to that same URL, the extension will show your note in context.

Chrome Extension

6. Send notes from Keep to other apps you use.

Some teams save content from other messaging or social media apps in Keep to reference later. Or, vice versa, you might use Keep to draft emails or social media posts on-the-go. Click on the three dots in the bottom right corner of your Keep app, select “send” and choose the app you want to share your note with.

7. Color-code or label your notes to find them quicker.

To organize your notes by color-coding them in Keep, at the bottom of a Keep note, select the three dots menu and choose from several colors to help you quickly identify a note. You might consider color-coding by task or deadline. If you’re working on your desktop, you can also use the Category Tabs for Google Keep Extension in Chrome to assign category names by color. It will look like this:

Changing colors in Keep

You can also add labels to your notes. Another way to locate your information in Keep is to add and create labels using #hashtags. When you create a note in the Keep app, you can type #label-name and Keep will prompt you to either apply a label if it already exists, or create one if it doesn’t. It’s a pretty handy shortcut.

8. Set reminders for yourself.

Notes matter only if you can execute on what your record. Keep lets you set up reminders which can help.

Select a note and click the finger icon at the top right of your screen in Keep (it has a string on it). When you do that, a pop-up window will give you options to set reminders. The great thing about this is that these reminders will alert you in other Google tools, like Calendar, Chrome or on your Android device.

Note: make sure you have Reminders enabled inside your Calendar app in order to see them. You can check out how to do that on our Help Center under the “Don’t see your Reminder” or “Switch between Tasks and Reminders” section.

Try Keep today

Keep is a great way to keep track of your work tasks. Learn more about how you can get started on our site.

Source: Drive


8 tips to help you keep up in Google Keep

Google Keep makes organizing information a cinch. You can easily jot down ideas or share to-dos with co-workers. We asked Mario Anima, product manager for Google Keep, to share some of his favorite Keep tips. This is what we learned.

1. Record voice notes.

For recording thoughts on the go, you can record voice memos within Google Keep on your Android or iOS device. Open up the Keep mobile app, click on the microphone icon at the bottom right of your screen and record your message. When you’re done talking, the recording will automatically end and a new screen will pop up with the text of your message and an audio file.


Record GIF

Click on “title” at the top of your audio file and name your note. Your note is automatically synced with the web app, too, so you can access it on your desktop.

2. Transcribe notes from pictures.

Sometimes a picture is worth a thousand words. Using Optical Character Recognition (OCR), Keep can transcribe text from pictures for you, so you don’t have to worry about typing up notes from a meeting or whiteboard session (shameless plug: you can also use Jamboard for that).

Just take a photo, select “Grab Image Text”  and Keep will transcribe your note.

OCR gif

3. Create drawings and even search handwritten notes.

You can sketch images in Keep. Select the pen icon at the bottom of your mobile screen and a bunch of options will appear. Play with colors, shades and more. Once you’re finished with your drawing, you can share it right away with coworkers. Or, you can come back to handwritten memos later by searching for what you wrote.

Speaking of search, you can also find images by searching for words contained within them. Say you snap a photo from a whiteboard and the image contains the word “Proposal.” Just search Keep for “proposal” and your image will appear.

4. Drag and drop notes from Keep into Google Docs.

Now you can use Keep directly within Docs—take notes you’ve created in Keep and drag them into client proposals and more.

If you’re in a Doc: click “Tools” on the menu bar, and then “Keep Notepad.” A sidebar will pop up with all of your note options. You can scroll through the list or use the search bar to jump right to the note you need. Once you’ve found it, drag-and-drop the note into your doc.

If you’re in the Keep app: select the note you want to send, click the three dots menu and click “Copy to Google Doc.”

You can also create notes in the Keep notepad while viewing a Doc. One bonus is that when you create a note in Docs, Keep creates a source backlink—so you can access the note in Keep and it will link back to the source document where the note was created.

Keep GIF

5. Use the Chrome Extension.

Create notes while you browse the web by downloading the Chrome Extension. One cool thing is that when you create a note using the extension, it saves the site URL with it. So if you browse back to that same URL, the extension will show your note in context.

Chrome Extension

6. Send notes from Keep to other apps you use.

Some teams save content from other messaging or social media apps in Keep to reference later. Or, vice versa, you might use Keep to draft emails or social media posts on-the-go. Click on the three dots in the bottom right corner of your Keep app, select “send” and choose the app you want to share your note with.

7. Color-code or label your notes to find them quicker.

To organize your notes by color-coding them in Keep, at the bottom of a Keep note, select the three dots menu and choose from several colors to help you quickly identify a note. You might consider color-coding by task or deadline. If you’re working on your desktop, you can also use the Category Tabs for Google Keep Extension in Chrome to assign category names by color. It will look like this:

Changing colors in Keep

You can also add labels to your notes. Another way to locate your information in Keep is to add and create labels using #hashtags. When you create a note in the Keep app, you can type #label-name and Keep will prompt you to either apply a label if it already exists, or create one if it doesn’t. It’s a pretty handy shortcut.

8. Set reminders for yourself.

Notes matter only if you can execute on what your record. Keep lets you set up reminders which can help.

Select a note and click the finger icon at the top right of your screen in Keep (it has a string on it). When you do that, a pop-up window will give you options to set reminders. The great thing about this is that these reminders will alert you in other Google tools, like Calendar, Chrome or on your Android device.

Note: make sure you have Reminders enabled inside your Calendar app in order to see them. You can check out how to do that on our Help Center under the “Don’t see your Reminder” or “Switch between Tasks and Reminders” section.

Try Keep today

Keep is a great way to keep track of your work tasks. Learn more about how you can get started on our site.

Source: Drive


Save that thought: How Instrument uses Jamboard to capture and share ideas

We all brainstorm differently. As Avi Couillard, a Senior Strategist at the digital agency Instrument, puts it: “Some people need to noodle on an idea, some need to converse with their team about it, and some need to visit it on their own terms.” For agencies like Instrument, inspiration can strike at any place and time. 

Instrument’s creative team has been using Jamboard for 10 months as a part of early testing cycles to facilitate brainstorms and execute on big ideas for clients, including Google. Along the way, the team has noticed an interesting shift in their creative process.

Jamboard 1

We interviewed members of Instrument’s creative team to tell us about this shift, and how Jamboard has changed their team’s approach to brainstorming.

Brainstorming before and after Jamboard

For Avi and his colleagues at Instrument, brainstorms looked different last year. “It used to be one person with bad handwriting, translating whiteboard notes into a spreadsheet,” says Avi. His colleague, UX Illustrator Sheri Smith, jokes: “That handwriting was usually mine.”

They’d leave meetings with a ton of ideas that were then assigned to other designers, illustrators or animators to interpret. “It was time-consuming and the process sometimes diluted creativity,” says Avi.

Jamboard and Instrument team

Now, instead of deciphering half-formulated ideas after the fact, Sheri visualizes concepts right away by sketching them on Jamboard as they’re mentioned. Avi and Sheri also bring remote colleagues into a brainstorm session. Other designers or programmers can join meetings via Hangout within the Jamboard, have PDF versions of work sent to them, or view “jams” from their phone, tablet or computer and rev on a concept right away.

Jamboard helps us focus more on the ideas, and less on translating creative direction to different teams. Avi Couillard
Senior Strategist, Instrument

“Jamboard helps us focus more on the ideas, and less on translating or assigning creative direction to different teams,” says Avi. His team is able to keep working on ideas after meetings wrap, too. “Because ideas from ‘jams’ are saved in Drive, they’re captured in their original form for everyone on the team. This provides the whole team with access so they can keep adding to them to make them better.” Once the work is complete, the team adds the final output into a Slides presentation to share with internal teams or clients to review.

Ideas from everywhere, everyone

With Jamboard, more team members are involved in the creative process earlier, including those who may not be viewed as traditional “creatives.” Says Andrew Barden, Senior Producer: “Jamboard democratizes brainstorms. Sometimes it’s easy to think ‘oh, I’m not a creative,’ but that’s not true. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work.”

Jamboard democratizes brainstorms. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work. Andrew Barden
Senior Producer, Instrument

Jamboard can also impact how organizations present work. Instead of a “grand unveil” of a polished product, other business units or your clients become broader extensions of your creative team. If you involve more team members in the thinking early on, they’re more likely to be invested in the end result. “Using Jamboard, I’ve had to get more comfortable with sharing my rough sketches or unfinished work to clients early on,” says Sheri. “But they like that. It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf.”

It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf. Sheri Smith
UX Illustrator, Instrument

Learn more about how your organization can get started with Jamboard.

Source: Google Cloud


Save that thought: How Instrument uses Jamboard to capture and share ideas

We all brainstorm differently. As Avi Couillard, a Senior Strategist at the digital agency Instrument, puts it: “Some people need to noodle on an idea, some need to converse with their team about it, and some need to visit it on their own terms.” For agencies like Instrument, inspiration can strike at any place and time. 

Instrument’s creative team has been using Jamboard for 10 months as a part of early testing cycles to facilitate brainstorms and execute on big ideas for clients, including Google. Along the way, the team has noticed an interesting shift in their creative process.

Jamboard 1

We interviewed members of Instrument’s creative team to tell us about this shift, and how Jamboard has changed their team’s approach to brainstorming.

Brainstorming before and after Jamboard

For Avi and his colleagues at Instrument, brainstorms looked different last year. “It used to be one person with bad handwriting, translating whiteboard notes into a spreadsheet,” says Avi. His colleague, UX Illustrator Sheri Smith, jokes: “That handwriting was usually mine.”

They’d leave meetings with a ton of ideas that were then assigned to other designers, illustrators or animators to interpret. “It was time-consuming and the process sometimes diluted creativity,” says Avi.

Jamboard and Instrument team

Now, instead of deciphering half-formulated ideas after the fact, Sheri visualizes concepts right away by sketching them on Jamboard as they’re mentioned. Avi and Sheri also bring remote colleagues into a brainstorm session. Other designers or programmers can join meetings via Hangout within the Jamboard, have PDF versions of work sent to them, or view “jams” from their phone, tablet or computer and rev on a concept right away.

Jamboard helps us focus more on the ideas, and less on translating creative direction to different teams. Avi Couillard
Senior Strategist, Instrument

“Jamboard helps us focus more on the ideas, and less on translating or assigning creative direction to different teams,” says Avi. His team is able to keep working on ideas after meetings wrap, too. “Because ideas from ‘jams’ are saved in Drive, they’re captured in their original form for everyone on the team. This provides the whole team with access so they can keep adding to them to make them better.” Once the work is complete, the team adds the final output into a Slides presentation to share with internal teams or clients to review.

Ideas from everywhere, everyone

With Jamboard, more team members are involved in the creative process earlier, including those who may not be viewed as traditional “creatives.” Says Andrew Barden, Senior Producer: “Jamboard democratizes brainstorms. Sometimes it’s easy to think ‘oh, I’m not a creative,’ but that’s not true. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work.”

Jamboard democratizes brainstorms. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work. Andrew Barden
Senior Producer, Instrument

Jamboard can also impact how organizations present work. Instead of a “grand unveil” of a polished product, other business units or your clients become broader extensions of your creative team. If you involve more team members in the thinking early on, they’re more likely to be invested in the end result. “Using Jamboard, I’ve had to get more comfortable with sharing my rough sketches or unfinished work to clients early on,” says Sheri. “But they like that. It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf.”

It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf. Sheri Smith
UX Illustrator, Instrument

Learn more about how your organization can get started with Jamboard.

Source: Drive


Save that thought: How Instrument uses Jamboard to capture and share ideas

We all brainstorm differently. As Avi Couillard, a Senior Strategist at the digital agency Instrument, puts it: “Some people need to noodle on an idea, some need to converse with their team about it, and some need to visit it on their own terms.” For agencies like Instrument, inspiration can strike at any place and time. 

Instrument’s creative team has been using Jamboard for 10 months as a part of early testing cycles to facilitate brainstorms and execute on big ideas for clients, including Google. Along the way, the team has noticed an interesting shift in their creative process.

Jamboard 1

We interviewed members of Instrument’s creative team to tell us about this shift, and how Jamboard has changed their team’s approach to brainstorming.

Brainstorming before and after Jamboard

For Avi and his colleagues at Instrument, brainstorms looked different last year. “It used to be one person with bad handwriting, translating whiteboard notes into a spreadsheet,” says Avi. His colleague, UX Illustrator Sheri Smith, jokes: “That handwriting was usually mine.”

They’d leave meetings with a ton of ideas that were then assigned to other designers, illustrators or animators to interpret. “It was time-consuming and the process sometimes diluted creativity,” says Avi.

Jamboard and Instrument team

Now, instead of deciphering half-formulated ideas after the fact, Sheri visualizes concepts right away by sketching them on Jamboard as they’re mentioned. Avi and Sheri also bring remote colleagues into a brainstorm session. Other designers or programmers can join meetings via Hangout within the Jamboard, have PDF versions of work sent to them, or view “jams” from their phone, tablet or computer and rev on a concept right away.

Jamboard helps us focus more on the ideas, and less on translating creative direction to different teams. Avi Couillard Senior Strategist, Instrument

“Jamboard helps us focus more on the ideas, and less on translating or assigning creative direction to different teams,” says Avi. His team is able to keep working on ideas after meetings wrap, too. “Because ideas from ‘jams’ are saved in Drive, they’re captured in their original form for everyone on the team. This provides the whole team with access so they can keep adding to them to make them better.” Once the work is complete, the team adds the final output into a Slides presentation to share with internal teams or clients to review.

Ideas from everywhere, everyone

With Jamboard, more team members are involved in the creative process earlier, including those who may not be viewed as traditional “creatives.” Says Andrew Barden, Senior Producer: “Jamboard democratizes brainstorms. Sometimes it’s easy to think ‘oh, I’m not a creative,’ but that’s not true. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work.”

Jamboard democratizes brainstorms. Ideas come from everywhere, and being able to iterate early in the process helps you produce your best work. Andrew Barden Senior Producer, Instrument

Jamboard can also impact how organizations present work. Instead of a “grand unveil” of a polished product, other business units or your clients become broader extensions of your creative team. If you involve more team members in the thinking early on, they’re more likely to be invested in the end result. “Using Jamboard, I’ve had to get more comfortable with sharing my rough sketches or unfinished work to clients early on,” says Sheri. “But they like that. It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf.”

It’s like if you buy a painting that you watched someone paint. That’s more valuable to you than buying it off the shelf. Sheri Smith UX Illustrator, Instrument

Learn more about how your organization can get started with Jamboard.

How The New York Times used the Google Sheets API to report congressional votes in real time

There’s a common phrase among reporters: “The news never sleeps.” This is why many news outlets rely on cloud-based productivity tools like Google Docs and Sheets to share information, check facts and collaborate in real time. And The New York Times is no exception.

In May 2017, the U.S. House of Representatives voted on a new health care law affecting millions of Americans. To report the news as fast as possible, The Times’ editorial team used Sheets to tally and display House votes in real time on NYTimes.com.


Engaging voters with the Sheets API

“People want to feel connected to the decisions their legislators make as soon as they make them,” said Tom Giratikanon,  a graphics editor at The Times. But rules in the House chamber make reporting on how every representative votes in real time difficult. Photography is restricted on the assembly floor, and there is a delay until all votes are displayed on the House website—a process that can sometimes take up to an hour.

To get around this lag, Giratikanon’s team used the Google Sheets API. The editorial team dispatched reporters to the chamber where they entered votes into a Google Sheet as they were shown on the vote boards. The sheet then auto-populated NYTimes.com using the Sheets API integration.

Says Giratikanon: “It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Sharing news immediately empowers our readers.”

It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Tom Giratikanon Graphics Editor, The New York Times
House votes

How it worked

To prep, Giratikanon tested the Sheets integration ahead of the House vote. He created a sheet listing the names of legislators in advance, so his team could avoid typos when entering data on the day of the vote. Next, he set up the Sheet to include qualifiers. A simple “Y” or “N” indicated “yes” and “no” votes.

After a few practice rounds, Giratikanon’s team realized they could add even more qualifiers to better inform readers–like flagging outlier votes and reporting on votes by party (i.e., Democrats vs. Republicans). The editorial team researched how each of the 431 legislators were expected to vote in advance. They created a rule in Sheets to automatically highlight surprises. If a legislator went against the grain, the sheet highlighted the cell in yellow and the editorial team fact-checked the original vote to reflect this in the article. Giratikanon also set up a rule to note votes by party.

As a result, The Times, which has roughly 2 million digital-only subscribers, beat the House website, reporting the new healthcare bill results and informing readers who were eager to follow how their legislator voted. 

NYT GIF

Try G Suite APIs today 

You can use Sheets and other G Suite products to help speed up real-time reporting, no matter the industry. Get started using the Sheets API today or check out other G Suite APIs, like the Slides API, Gmail API or Calendar API.

Source: Google Cloud


How The New York Times used Google Sheets to report congressional votes

There’s a common phrase among reporters: “The news never sleeps.” This is why many news outlets rely on cloud-based productivity tools like Google Docs and Sheets to share information, check facts and collaborate in real time. And The New York Times is no exception.

In May 2017, the U.S. House of Representatives voted on a new health care law affecting millions of Americans. To report the news as fast as possible, The Times’ editorial team used Sheets to tally and display House votes in real time on NYTimes.com.


Engaging voters with the Sheets API

“People want to feel connected to the decisions their legislators make as soon as they make them,” said Tom Giratikanon,  a graphics editor at The Times. But rules in the House chamber make reporting on how every representative votes in real time difficult. Photography is restricted on the assembly floor, and there is a delay until all votes are displayed on the House website—a process that can sometimes take up to an hour.

To get around this lag, Giratikanon’s team used the Google Sheets API. The editorial team dispatched reporters to the chamber where they entered votes into a Google Sheet as they were shown on the vote boards. The sheet then auto-populated NYTimes.com using the Sheets API integration.

Says Giratikanon: “It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Sharing news immediately empowers our readers.”

It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Tom Giratikanon
Graphics Editor, The New York Times
House votes

How it worked

To prep, Giratikanon tested the Sheets integration ahead of the House vote. He created a sheet listing the names of legislators in advance, so his team could avoid typos when entering data on the day of the vote. Next, he set up the Sheet to include qualifiers. A simple “Y” or “N” indicated “yes” and “no” votes.

After a few practice rounds, Giratikanon’s team realized they could add even more qualifiers to better inform readers–like flagging outlier votes and reporting on votes by party (i.e., Democrats vs. Republicans). The editorial team researched how each of the 431 legislators were expected to vote in advance. They created a rule in Sheets to automatically highlight surprises. If a legislator went against the grain, the sheet highlighted the cell in yellow and the editorial team fact-checked the original vote to reflect this in the article. Giratikanon also set up a rule to note votes by party.

As a result, The Times, which has roughly 2 million digital-only subscribers, beat the House website, reporting the new healthcare bill results and informing readers who were eager to follow how their legislator voted. 

NYT GIF

Try G Suite APIs today 

You can use Sheets and other G Suite products to help speed up real-time reporting, no matter the industry. Get started using the Sheets API today or check out other G Suite APIs, like the Slides API, Gmail API or Calendar API.

Source: Drive


How The New York Times used the Google Sheets API to report congressional votes in real time

There’s a common phrase among reporters: “The news never sleeps.” This is why many news outlets rely on cloud-based productivity tools like Google Docs and Sheets to share information, check facts and collaborate in real time. And The New York Times is no exception.

In May 2017, the U.S. House of Representatives voted on a new health care law affecting millions of Americans. To report the news as fast as possible, The Times’ editorial team used Sheets to tally and display House votes in real time on NYTimes.com.


Engaging voters with the Sheets API

“People want to feel connected to the decisions their legislators make as soon as they make them,” said Tom Giratikanon,  a graphics editor at The Times. But rules in the House chamber make reporting on how every representative votes in real time difficult. Photography is restricted on the assembly floor, and there is a delay until all votes are displayed on the House website—a process that can sometimes take up to an hour.

To get around this lag, Giratikanon’s team used the Google Sheets API. The editorial team dispatched reporters to the chamber where they entered votes into a Google Sheet as they were shown on the vote boards. The sheet then auto-populated NYTimes.com using the Sheets API integration.

Says Giratikanon: “It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Sharing news immediately empowers our readers.”

It’s easy to feel like decisions are veiled in the political process. Technology is a powerful way to bridge that gap. Tom Giratikanon Graphics Editor, The New York Times
House votes

How it worked

To prep, Giratikanon tested the Sheets integration ahead of the House vote. He created a sheet listing the names of legislators in advance, so his team could avoid typos when entering data on the day of the vote. Next, he set up the Sheet to include qualifiers. A simple “Y” or “N” indicated “yes” and “no” votes.

After a few practice rounds, Giratikanon’s team realized they could add even more qualifiers to better inform readers–like flagging outlier votes and reporting on votes by party (i.e., Democrats vs. Republicans). The editorial team researched how each of the 431 legislators were expected to vote in advance. They created a rule in Sheets to automatically highlight surprises. If a legislator went against the grain, the sheet highlighted the cell in yellow and the editorial team fact-checked the original vote to reflect this in the article. Giratikanon also set up a rule to note votes by party.

As a result, The Times, which has roughly 2 million digital-only subscribers, beat the House website, reporting the new healthcare bill results and informing readers who were eager to follow how their legislator voted. 

NYT GIF

Try G Suite APIs today 

You can use Sheets and other G Suite products to help speed up real-time reporting, no matter the industry. Get started using the Sheets API today or check out other G Suite APIs, like the Slides API, Gmail API or Calendar API.