thatsnice

In Taiwan, shops / restaurants are open as normal and people are walking around freely, other than the tiny percent in quarantine. Meanwhile Europe and the US are increasingly locked down. So which one has more freedom?

US$1 ~ 30.2NT so the original numbers seem correct.

I think it’s because there are 2 of them, each on the $6 plan. G Suite charges per person.

I pay for G Suite as a freelancer. It lets me use my own domain for email and meeting requests instead of an @gmail account.

FYI, there is a typo in the link to your blog.

Interesting idea, thanks. There's often multiple levels of nested data, would you want to see each level in a new sheet?

I made a Google spreadsheet add-on [1] that contains 3 built-in options for converting nested JSON to tabular format.

Method 1: drills into nested json objects and arrays and returns the key names as headers, key values as rows. In cases with multiple nested values, they get returned into multiple columns, differentiated by a number, e.g. orders > products > 1, orders > products > 2.

Method 2: same as above but returns all nested data into a single column, e.g. a single column named orders > products. This can break the association between JSON elements, but is more convenient for certain types of analysis.

Method 3: concatenates all the elements of each nested object into a single cell, separated with pipes.

In some cases (e.g. when the primary object of interest is nested inside another object) there are still problems recognizing what keys should represent rows vs columns, but in my tests the above 3 algorithms cover most of the use cases for spreadsheets.

[1] https://mixedanalytics.com/knowledge-base/report-styles/

That was very cool & educational.

I also posted one recently, a plugin to connect to APIs directly in Google Sheets [1]. The primary use case I had in mind was for people looking to grab data from various APIs, in which case it's pretty clear why someone would want to directly access the output in Google Sheets. However, I was surprised to discover a lot of people are actually using it as an alternative to CMSes like Wordpress, like bolting it together to other plugins and sheets to create their own apps. It's a trend for sure, I think it all falls under the "low code/no code" movement.

[1]: https://chrome.google.com/webstore/detail/api-connector/cebn...

Hi HN, a couple days ago I released a Google Sheets Add-on to pull JSON API data directly into Google Sheets. You can enter the URL, query strings, and any required headers into the Add-on sidebar, and can make dynamic requests by referencing cells in the sheet. For example, the API request URL can point to a cell containing today's date, which is useful if you want to refresh the data every day.

I made this after working on a lot of reporting projects that required aggregating API data from multiple marketing & analytics platforms.

As a quick meta-example, here's a Google Sheet that checks the Hacker News API for current Show HN's and automatically refreshes every hour: https://docs.google.com/spreadsheets/d/14RsAm8s5JtsH2ots79c0...

Thanks, filipm. It's interesting, the intro page does actually list all the things it audits in the box that says Site Settings, Goals and Funnels, Site Search, Campaign Tracking, etc. Did you not see that (perhaps because it's below the fold) or was it just not clear enough?

You're right, thank you for the feedback. It slipped through since I just made this new site last week. I am a web analyst and not a phisher but I see how it looks suspicious -- I'm editing the links now!

Thanks philipn. Typically web analytics firms call this type of account setup and implementation review an "audit", but you're right, it's not necessarily clear. Let me think what else I can call it... GA is pretty complex these days and many accounts have setup problems. So the point of this tool is to scan through an account and identify any issues.

As for handing over GA info, it's only handing it over to Google as they handle all login and authorization. The data can only be seen by you and is not accessed or stored on our side. However, someone else voiced the same concern, so I will definitely make it more clear.

I have been working in the field of web analytics for many years but this is a brand new site (old one was at akravitz.com) About page is coming!

Thanks for your feedback. They are not the same service -- the web app is a free automated audit that checks for 17 different issues I regularly find while auditing client accounts (for example, problems with event tracking, view filters, marketing campaign tags, etc.) The $3000 audit is a full service audit that is usually requested by large e-commerce sites with custom, complex set-ups. I will make an effort to differentiate these more clearly. Please go ahead and press the button :)

Thank you for your feedback. Those are all great ideas. Actually none of the user's GA data is directly accessed or stored whatsoever -- it's all done through the Google API using oAuth so we can't see any of their account data. But I will add in some text to explain that more clearly. Thanks again!