Zoho Show integration with Zoho Sheet

Zoho Show integration with Zoho Sheet

The external data linking option in data fields allows you to integrate Zoho Sheet with Zoho Show. You can link any cell in the spreadsheet to your presentation as a data field. Any changes made to the spreadsheet can be synced with your presentation.
 
  1. Create a Zoho Sheet with the required data.
  2. Navigate to the required slide in your presentation, click Text from the top, and choose Data Fields within it.
    You can also enter $ in the required slide and choose Create New to create a new data field.
    The data fields window will appear.
  3. Click Add New.



  4. By default, the data field will be named as Untitled 1. You can rename it.
  5. Select External from Source. By default, Zoho Sheet will be selected.
  6. From the Document dropdown, select the spreadsheet. 
  7. Click the    to choose a spreadsheet from WorkDrive.
  8. From the Sheet dropdown, select the sheet in which your data is stored.


You can link a cell, range, or a named range data to your presentation.

Cell:
  1. Click Cell next to Data and enter the cell location in which the data is stored.
    Alternatively, you can also click Select Range, choose a cell from the spreadsheet, and click Update from the top-right corner.
  2. Click next to Value to fetch a different data.
  3. Click Insert field.
  4. To use the added data field in other slides, navigate to the required slide, enter the $ symbol, and from the dropdown choose the data field that you wish to insert.


Range:
  1. Click Range and enter the range from the sheet. 
    Alternatively, you can also click Select Range, select the required cell range from the spreadsheet, and click Update from the top-right corner.
  2. Click the Insert as Table dropdown to select between Insert as Table or Insert as Chart to insert the selected range as a table or a chart.


Named Range:
  1. Click Named Range and choose the required Named range from the Select Range dropdown. 
  2. Click the Insert as Table dropdown to select between Insert as Table or Insert as Chart to insert the selected range as a table or a chart.
When changes are made to the Sheet, you can use the Sync icon to sync the values to your presentation.
When you map values from the Sheet, your collaborators will be able to view the mapping. However, only those with access to the Sheet will be able to sync the changes.

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION









                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Zoho Show integration with Zoho Flow

                                                                                                            Zoho Flow is an integration platform that helps you connect two different apps without any code. It works on the trigger-action methodology, where when an event is triggered in an app, you can instruct another app to perform an action. For example, ...
                                                                                                          • Add and manage data fields

                                                                                                            A data field is used to store values and access them when required. With the Zoho Show app, you can define a data field and use it across your presentation. It can be used to store numerical and alphanumeric information. The data field is ...
                                                                                                          • Zoho Show integration with Zapier

                                                                                                            Zapier lets you connect an app with thousands of other popular apps to automate your work. Zaps are workflows that link two or more apps together. Zap consists of two parts: a trigger and an action. A trigger is an event in an app that starts the Zap ...
                                                                                                          • Overview of Zoho Show for Slack

                                                                                                            Zoho Show integrates with many external services to enhance its presentation services. One such integration is that with Slack. Once the Show app for Slack is installed, the app listing page opens in a new tab. The app lists under the Recent apps in ...
                                                                                                          • Install the Zoho Sprints add-on for Zoho Show

                                                                                                            Let's say you are going to deliver a presentation about an ongoing project (developed using agile methodology) to your manager. In such a case, you may want to include a few reports in the presentation so they can easily track and monitor the ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources