New Features and Updates
      Back to home
      1. Knowledge Center
      2. New Features and Updates

      July 24, 2020 | Google Sheets Integration. -BETA

      July 24, 2020 | Google Sheets Integration. -BETA New Features and Updates

      Google Sheets Integration -BETA | Reach Reporting

      *Now connect google sheets data to use within Reach Reporting.

      NOT CURRENTLY USING REACH REPORTING?

      Now you can connect a google sheet directly in Reach Reporting.

      A 2-minute overview of the Google Sheets integration.

      Follow these steps:

      Simply go to the "Sheets" icon located in the lower left after opening a company.

      Step 1: Authenticate a Google account to allow Reach to access to view a Google Sheet.

      Step 2. You can use the template or just make sure the Google sheet has the correct data-name and month formatting. If you use the template it is view only so you need to make a copy of it.

      Formatting Rules

      1. Cell A1 Should display "Id," and below all the IDs of the row should be displayed. There must not be duplicates. A unique Id can be anything if there isn't one currently being used.
      2. Cell B1 Should display "Name," and below all the Names of the IDs should be displayed.
      3. Any other columns can be labeled as dates (Jan 2020) where the month and the year are displayed. There must not be duplicates.

      Step 3: Once you connect the Google Sheet, you can use this data throughout the Reach Reporting software.

      Step 4: If you make changes to the sheet, make sure to simply click the sync button next to the sheet that has changed.

      Who can access it?

      Once you authorize a google account, it is tied to your Reach Reporting login so that way it is authorized to use on any company you have access to and is specific to you.

      1. Other Team Members can't use your Google Account to connect a google sheet.
      2. Team Members can sync any existing Google Sheet that is connected to the company.
      3. Team Members can authorize their own Google Account to connect additional sheets.
      4. A Google Sheet can be used in multiple companies.

      NOT CURRENTLY USING REACH REPORTING?

      learn more

      Financial Visual Reporting Made Easy

      Did this answer your question?

      We are dedicated to helping you.

      Reach Reporting is dedicated to helping provide a knowledge base that is easy to understand and informative. If you still have questions that have not been answered, please let us know by emailing support@reachreporting.com, chatting with our support team, or calling us at (877) 467-7637. We are here to ensure that you have a positive experience with Reach Reporting, as we want to continue to be the reporting solution you trust. 

      You are appreciated,

      The Reach Reporting Team.