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.

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure Forms

                              WCAG

                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now






                                                            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

                                                                  Use cases

                                                                  Make the most of Zoho Desk with the use cases.

                                                                   
                                                                    

                                                                  eBooks

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

                                                                   
                                                                    

                                                                  Videos

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

                                                                   
                                                                    

                                                                  Webinar

                                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                                   
                                                                    
                                                                  • Desk Community Learning Series


                                                                  • Meetups


                                                                  • Ask the Experts


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner



                                                                    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 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 CRM

                                                                                                                              Data fields are used to store values and provide access to them throughout your presentation. With the external data fields feature in Show, you can merge records from Zoho CRM. For example, a sales team can store client details like company name, ...
                                                                                                                            • 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 ...
                                                                                                                              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