CoMagic Creates Free Google Sheets Connector
Posted: Mon Dec 23, 2024 8:30 am
Content
What data can be received through the connector
How to connect the connector
Which BI systems can you transfer data to from Google Sheets and how to do it
Now you can effortlessly transfer data from CoMagic to Google Sheets and visualize it anywhere: in Google Sheets itself or BI systems. I will tell you why this is important and what you need to set it up.
Every analyst uses tables when working with data. Be it telegram best of vietnam Microsoft Excel, Open Office, Numbers, etc. Google Sheets allowed us to look at this work in a different way. In 2006, the “corporation of good” offered users to work on documents online. Thanks to this, we can now jointly edit information, provide access to the right people, but most importantly, use Google Sheets as a source for BI systems in which this data is visualized. Even for the world- famous coronavirus expansion dashboard, Google Sheets were initially used, from which online data on the epidemiological situation was loaded.
We've noticed that our customers are increasingly using Google Sheets.
You can download from your personal account in a couple of clicks.
We added this feature a long time ago, but exporting to Google Sheets alone was not enough, because we wanted to present the information beautifully in graphs and dashboards. To simplify the process of transferring data to third-party systems, we used the new Google Apps Script tool. It allows you to write scripts to solve such problems. One example of using Google Apps Script is setting up the Google Data Studio connector .
And then we thought: but it’s probably not very convenient to constantly download reports from CoMagic to Google Sheets? We love our users, after all. Why not automate the data upload from CoMagic to Google Sheets in real time directly to a file specially created for this purpose? Just click “Download” in it, and the data will be updated.
So we made a connector to our Data API to provide customers with a convenient and simple way to use Google Apps Script together with Google Sheets. Simply put, now you can get the necessary CoMagic data in your Google spreadsheet in a few clicks for further processing or transferring it to a BI system.
What data can be received through the connector
calls - data returned by the get.calls_report method
chats - data returned by the get.chats_report method
requests - data returned by the get.offline_messages_report method
goals - data returned by the get.goals_report method
all requests - data returned by the get.communications_report method
statistics on advertising campaigns - data returned by the get.campaign_daily_stat method
What data can be received through the connector
How to connect the connector
Which BI systems can you transfer data to from Google Sheets and how to do it
Now you can effortlessly transfer data from CoMagic to Google Sheets and visualize it anywhere: in Google Sheets itself or BI systems. I will tell you why this is important and what you need to set it up.
Every analyst uses tables when working with data. Be it telegram best of vietnam Microsoft Excel, Open Office, Numbers, etc. Google Sheets allowed us to look at this work in a different way. In 2006, the “corporation of good” offered users to work on documents online. Thanks to this, we can now jointly edit information, provide access to the right people, but most importantly, use Google Sheets as a source for BI systems in which this data is visualized. Even for the world- famous coronavirus expansion dashboard, Google Sheets were initially used, from which online data on the epidemiological situation was loaded.
We've noticed that our customers are increasingly using Google Sheets.
You can download from your personal account in a couple of clicks.
We added this feature a long time ago, but exporting to Google Sheets alone was not enough, because we wanted to present the information beautifully in graphs and dashboards. To simplify the process of transferring data to third-party systems, we used the new Google Apps Script tool. It allows you to write scripts to solve such problems. One example of using Google Apps Script is setting up the Google Data Studio connector .
And then we thought: but it’s probably not very convenient to constantly download reports from CoMagic to Google Sheets? We love our users, after all. Why not automate the data upload from CoMagic to Google Sheets in real time directly to a file specially created for this purpose? Just click “Download” in it, and the data will be updated.
So we made a connector to our Data API to provide customers with a convenient and simple way to use Google Apps Script together with Google Sheets. Simply put, now you can get the necessary CoMagic data in your Google spreadsheet in a few clicks for further processing or transferring it to a BI system.
What data can be received through the connector
calls - data returned by the get.calls_report method
chats - data returned by the get.chats_report method
requests - data returned by the get.offline_messages_report method
goals - data returned by the get.goals_report method
all requests - data returned by the get.communications_report method
statistics on advertising campaigns - data returned by the get.campaign_daily_stat method