Comments for Mixed Analytics

Comment on Import Google Business Profile Data to Google Sheets by pradz

pradz — Fri, 06 Dec 2024 12:56:22 +0000

Hi Support Team,

How can i get month wise?

Comment on New: Looker Studio GA4 API Template (Better Than Data) by Shah Rizal

Shah Rizal — Fri, 06 Dec 2024 05:54:25 +0000

Hello, my name is Shah Shafie. Actually I confused about CRM report in my Google drive, Google sheets and also. I not remember all. Please help.

Comment on Multi-Login Issue by Liam

Liam — Wed, 04 Dec 2024 01:58:12 +0000

In reply to Liam.

Just tried with a personal google account on the same computer in incognito mode and ran into the same issue.

Comment on Multi-Login Issue by Liam

Liam — Wed, 04 Dec 2024 01:28:33 +0000

I have tried both the logging out and incognito mode methods, getting the same error no matter what. Might be connected to the fact that I have both a workspace and personal google account linked to my work email address, but not sure. Any suggestions?

Comment on Edit Fields by Anonymous

Anonymous — Tue, 03 Dec 2024 21:34:00 +0000

I had manually added a new column to be the last column (after all columns are mapped) in order to record the date and time when a new row is inserted (I can't use the Api connector's built in Add Timestamp since it updates the time on every run). But every time I run a request, my new column is removed from the sheet, likely because it's not part of the field mapping. Is there a way to have this column remain?

Comment on Use Cell Values in Requests by Anonymous

Anonymous — Tue, 03 Dec 2024 15:11:15 +0000

My sheet can pull over 100 new rows everyday with each API call and at least 20 columns for each row. I want to make a POST request to Kustomer, and can't send these rows in a single request body since Kustomer won't be able to parse the data and differentiate each object. Instead, is there a way to trigger a POST request through the sidebar every time there is a new row and dynamically reference it's row/column cells in the request body? Thank you

Comment on Create a Request by Ian

Ian — Thu, 28 Nov 2024 12:32:53 +0000

In reply to FR.

Hi - please use page parameter pagination, as specified in our CoinGecko how-to guide: https://mixedanalytics.com/knowledge-base/import-coingecko-data-to-google-sheets/

Comment on Pagination Handling by Anonymous

Anonymous — Wed, 27 Nov 2024 23:19:18 +0000

Hi, I want to fetch data from CoinGecko via API Connector. Unfortunately only 250 line items were loaded. How can I handle more line items? I tried already to use pagination but so far not successful. Can you help me?
Thx
Frank

Comment on Create a Request by FR

FR — Wed, 27 Nov 2024 23:00:45 +0000

I try to fetch Data from CoinGecko. Unfortunately I can only fetch 250 lines with the market data via the Connector. Also I tried to use pagination with different options. But nothing helped so far. Can you support?

Comment on Import CoinMarketCap Data to Google Sheets by Gus

Gus — Wed, 27 Nov 2024 15:51:02 +0000

Hi, thanks for the information, very helpful. I think I am almost there. But when I refresh it returns the following message: { "status": { "timestamp": "2024-11-27T15:49:32.185Z", "error_code": 1002, "error_message": "API key missing.", "elapsed": 0, "credit_count": 0 } } Can you help me?