---
title: "Retrieve comments with emoji reactions from Google Docs, Google Slides and Google Sheet using Google Apps Script"
author: "Martin Hawksey"
date: 2023-10-31T23:42:58+00:00
canonical_url: https://pulse.appsscript.info/p/2023/10/retrieve-comments-with-emoji-reactions-from-google-docs-google-slides-and-google-sheet-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/10/retrieve-comments-with-emoji-reactions-from-google-docs-google-slides-and-google-sheet-using-google-apps-script.md
categories:
  - "Docs"
  - "Intermediate"
  - "Sheets"
  - "Slides"
  - "Snippet"
  - "Solutions"
tags:
  - "tanaikech.github.io"
featured_image: https://pulse.appsscript.info/files/2023/10/fig1.png
description: "Here's a clever workaround by Kanshi Tanaike for retrieving comments with emoji reactions in Google Docs, Slides, and Sheets using Google Apps Script. The process to achieve this is a little convoluted in that Google Docs, Slides and Sheets are exported in Microsoft equivalent formats, then re-imported into Google formats. To remove some of the pain the post includes sample code snippets for achieving this, which can easily be adapted."
---

# Retrieve comments with emoji reactions from Google Docs, Google Slides and Google Sheet using Google Apps Script

![Retrieve comments with emoji reactions from Google Docs, Google Slides and Google Sheet using Google Apps Script](https://pulse.appsscript.info/files/2023/10/fig1.png)

> [https://tanaikech.github.io/2023/10/26/retrieve-comments-with-emoji-reactions-from-google-documents-google-slides-and-google-spreadsheets-using-google-apps-script/](https://tanaikech.github.io/2023/10/26/retrieve-comments-with-emoji-reactions-from-google-documents-google-slides-and-google-spreadsheets-using-google-apps-script/)
> This report introduces the method for retrieving the Emoji reactions from the comments in Google Docs files (Google Documents, Google Slides, and Google Spreadsheets) using Google Apps Script.

Here’s a clever workaround by Kanshi Tanaike for retrieving comments with emoji reactions in Google Docs, Slides, and Sheets using Google Apps Script. The process to achieve this is a little convoluted in that Google Docs, Slides and Sheets are exported in Microsoft equivalent formats, then re-imported into Google formats. To remove some of the pain the post includes sample code snippets for achieving this, which can easily be adapted.

Source: *[Retrieve Comments with Emoji Reactions from Google Documents, Google Slides, and Google Spreadsheets using Google Apps Script*](https://tanaikech.github.io/2023/10/26/retrieve-comments-with-emoji-reactions-from-google-documents-google-slides-and-google-spreadsheets-using-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/10/retrieve-comments-with-emoji-reactions-from-google-docs-google-slides-and-google-sheet-using-google-apps-script/](https://pulse.appsscript.info/p/2023/10/retrieve-comments-with-emoji-reactions-from-google-docs-google-slides-and-google-sheet-using-google-apps-script/)*