Syncing Sql Query Table to Zoho Sheets

Syncing Sql Query Table to Zoho Sheets

I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is there any way that I can add new rows at the bottom while syncing so that my data won't be affect.


      • Sticky Posts

      • Introducing Forms in Zoho Sheet

        We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you

      • Meet the latest feature of Zoho Sheet: Lock Cells

        We are happy to announce the release of one of the most awaited features in Zoho Sheet. ​You can now lock the cells that you wish to keep ​secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,

      • Feature enhancement: Highlight rows based on a cell value

        Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw

      • Revamped Print in Zoho Sheet—customized for paper

        The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.

      • Slicers are now available in Zoho Sheet—filter your data interactively

        At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

        • Recent Topics

        • Reproducible bug in Zoho Workdrive sync agent for Windows

          I've observed a recurring and reproducible failure in the Windows desktop app for WorkDrive, related to the registration of the OverlayIcon handlers that are added to the registry. When I installed Windows 11, I configured my ProfilesDirectory (C:\Users,

        • Emails to Hotmail/Outlook are being blocked – IP blacklisted

          Hello, I am using Zoho Mail with the domain ghayatalbahr.com, and I’m unable to send emails to Hotmail/Outlook addresses. The bounce message says that Zoho’s sending IP (199.67.81.1) is on a block list (S3150). Please help by either switching my account

        • Limits on test emails

          Why do you have limits on test emails? Can they be removed?

        • CORS problem with APIs

          When I try to call web services from Postman, I don't have a problem I can get responses without problem. But when I try to call Zoho web services from my web application I have a CORS problem. For local development I download a Chrome extension for prevent

        • Users cannot set due date?

          The due date field under the "Edit Layout" page is set to not visible and I cannot change it by clicking on the little red light bulb. I was almost certain that users are able to view and edit the due date at the time of ticket creation. Is there a way to make the due date field visible to users? Thanks, Jamie

        • Light Agents

          Can Light agents extract reports from the Analytics module? Kindest Regards Ahmed

        • Opening & Closing Balance - Zoho Desk

          I would like to track the opening and closing balance of total tickets for each day in Zoho Desk. I need a way to represent this data in Zoho Analytics or another application for easy tracking.

        • invokeUrl - send body with GET request

          Hello, I am trying to utilize the invokeUrl Deluge function to send a GET request with JSON request details in the body to my Node.js (Express) API. Request information is sent in the body because the request data can exceed URL parameter length and because

        • Bug Alert - Duplication of Tickets in Zoho Support

          Due to a bug that crept into our email infrastructure, duplicate copies of emails were fetched into and displayed within Zoho Support today.  We've already identified the root cause and built a fix for it.  Additionally, an automatic background program will identify and clean up all the duplicate emails you might have received so far.  The same should be rolled out to all users shortly. We'll keep you posted here as and when the fix is applied.  We apologize for the inconvenience and understand that,

        • Zoho User Group (ZUG) Meetup is Back in the USA!

          We’re excited to bring the Zoho User Group (ZUG) Meetup back to the USA! Join us for an insightful session where we’ll explore how businesses of all sizes can optimize their lead nurturing process using Zoho SalesIQ and other Zoho applications. Session

        • Ordering of Teams

          Hi there, Currently, we cannot order Teams in Zoho Desk. Teams are ordered as they were created. It would be really helpful if we could customise the order of Teams. For example: We have the following Teams: Shipping Customer Service Sales Compliance

        • B2B2B SaaS: How to visually identify affiliate-referred clients in Zoho Desk ticket listings?

          We're using Zoho Desk standalone (without CRM) for our B2B2B SaaS company, where we support both direct clients and their end customers. Challenge: We need agents to visually identify tickets from clients who were referred by specific affiliates directly

        • You should be able to edit the invite template of Zoho Meeting when sending it to an email

          What the title says. Is there a way I don't know about?? Thanks. FV

        • New App Menu Doubt and Question

          Hi member, Now my Creator C6 able to have the Newest App Menu. The UI is nice. But I have several questions about this feature. 1) I construct two Title on above a component. But only one Title will be shown. Is it a bug or intended behavior? In fact,

        • Zoho Projects - Quarterly Updates | Q1 2025

          Hello Users, We would like to share the latest updates for this quarter. Here is a round-up of the features and enhancements we rolled out in Q1: Working with Zoho Projects data in Power BI? Integrate Zoho Projects to Power BI and sync module data (from

        • Customers receiving two email notifcations each time an invoice is created

          Customers are receiving two emails each time we create a new invoice. They are not duplicates, as there is only one invoice in their account + in the email workflow. But still, they receive the email two times in a row at the same time. We have gone over

        • Zoho Developer Community Monthly Digest – March 2025

          Hello everyone, This month is packed with exciting product updates, learning sessions, and powerful community conversations that remind us: sometimes, the best solutions come from a single shared question. From quick workarounds to upcoming training events

        • jsonarray.

          Zoho CRM says "Invalid input for Product_Details. The expected input type is jsonarray."

        • Caldav Synchronizer shows error System.Xml.XmlException: Root element is missing

          We are using Outlook 2019 and CalDav Synchronizer to sync our calendars. Since ~two weeks we are not able to sync anymore, we always get the Error System.Xml.XmlException: Root element is missing I attached a screenshot with the full error message. System.Xml.XmlException:

        • What is the module name for "Vendors" in a call to info zoho.books.getRecordsByID?

          What is the module name for "Vendors" in a call to info zoho.books.getRecordsByID? "vendors" is incorrect. zoho.books.getRecordsByID("vendors", books_organization_ID, vendor_id, "books_full_access");

        • How to set the width of the columns in a script

          Dear community, hope you all are doing great, I'm creating this thread to check the following: I have a deluge script that creates a PDF file with a table and I'm strugling to set the width of the columns. Here's the snippet of my code which creates this

        • Any idea for loading animation workaround?

          On my application i have page with ZML <image>  which has attribute action='Function'. when the image (icon) pressed a function get called and sometimes the function takes some time (API Calls).  For making a reasonable UX i would like to show a sign

        • Generate Payment Link - ZOHO Books by an API

          Hello Team, is there any way we can Generate a Payment Link - ZOHO Books by an API, if anyone has any idea about this please do comment? Thanks & Regards Piyush Goyal

        • Email hook is triggered twice for a single email

          I have a problem with Zoho Flow. Started yesterday. Every incoming email is processed twice by the same flow, but there is only one entry in the history. On the dashboard I can see that the flow was executed 6 times (3 emails received) and I have 3 entries

        • Opportunity Reappears in Pipeline After Exiting Blueprint – Need to Prevent This

          An opportunity reappears in the Pipeline after exiting the Blueprint, and the user is able to move it — I don't want this to happen. Can someone help me?"

        • Fetch a task by ID

          Hi there, is there an option to fetch "Zoho Project " task by ID in "Zoho Flow" or any really way to fetch task currently. Thanks in advance

        • Perfomance Management - Zoho People

          Hi team, I am looking for performance management data such as KRA, goals, feedback, appraisals, etc., in Zoho Analytics. However, I am unable to find these metrics while editing the setup. Could you please confirm whether these fields are available in

        • Zoho CRM Canvas is slow in loading

          Hi, the new Canvas feature in Zoho CRM is very interesting but the layout becomes very slow to load. I mean using the standard layout for Contacts detail view takes about 2,200 ms to completely load the page on my Chromebook (and my connection speed is

        • What's New in Zoho Books - June 2024

          Hello users, We are back with new features and improvements to enhance your accounting experience in Zoho Books. Keep reading to discover what's new in Zoho Books this June. Generate ABA Files for Bills [Australia Edition] An ABA file (Australian banking

        • What's New in Zoho Books - May 2024

          Hello users, We've rolled out new features and enhancements to elevate your accounting experience in Zoho Books. Dive in to discover what's new in Zoho Books this May. Alipay Payment Method for Stripe Alipay, a popular digital wallet in China, is now

        • Annoying Pop-Up Zoho Advertisements and Announcements Within Apps

          It is beyond frustrating to have to close out Zoho's announcements for Webinars, Zoholics, updates, events, etc while working within ANY of the Zoho apps. I see it when accessing Zoho One, Cliq, Creator, and CRM. Zoho boasts to be a professional solution

        • Linking fields from different modules

          is it possible to have fields from 2 different modules linked together?  For example, within our opportunity module we have an account field.  Can we create a new module that is linked to the opportunity module with the account field?  So when the account field is updated in the opportunity module, it also gets updated in the new module?

        • Detect previously signed PDF in package

          When you include a previously signed PDF document in a package, if that document had text tags in it, Zoho Sign will add new signature fields on top of the real signatures. That should be a disfavored action for two reasons: (1) it's almost never going

        • Boost your productivity :: Scheduled Time Log Reports

          Hello Everyone, In this series of power of Automation, I would like to highlight a handy automation feature designed to make our life easier - Schedule export for time logs. With this feature, we can automate the export and delivery of timesheet reports

        • My mobile phone marked as spam

          Hi there, I attempted to add my mobile phone, from Canada, to the settings under my Zoho vault account. An alert came up saying it is marked as spam when it is definitely not spam. What do you suggest I do next? Thanks so much!

        • Tip #5: Setting access rights at the subfolder level

          Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.

        • New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!

          Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementally

        • Automatically charge tax on shipping

          When we do a quote we charge tax on the subtotal cost, but when I put in shipping I have to manually select a tax amount. How do I have it automatically apply tax to the shipping as well? I have provided a screenshot that shows I have to manually do this.

        • What's New in Zoho Books - July 2024

          Hello users, We are back with a bunch of new features and enhancements this month to make your accounting experience seamless. Keep reading to learn more about them. Explore An Enhanced Reports Module We've streamlined the Reports page to increase efficiency

        • Client Script - getBlueprintTransitions returns array of empty objects

          Just like the title says, when I'm getting the Blueprint transitions via client script, the function returns an array of empty objects. It does correctly get the number of blueprint transitions on the page, however all the objects are completely empty.

        • Next Page