Tag: Google

Google accounts activity recording – Information Security Stack Exchange

I don’t know how Google activity recordings operate, but what I found strange is that the activity seems the same for all my Google accounts logged in on my phone, whereas Google, in one of its pages says

“To help keep your activity private:

Your Google Account comes with built-in security designed to detect and block threats like spam, malware, viruses, and hackers.
Your activity is stored securely, using industry-leading encryption.
Each Google Account has its own activity. If you have multiple Google Accounts, activity from each account is kept completely separate.“,
so the arising question is, how does Google exactly record activity? Does it record it for each account on its own and the latter’s activities of the apps they’ve been installed from it? Or does it record the Google activity of the phone as a whole? It seems that the second option applies, despite their written policy I quoted above.

Can anyone elaborate further?

google search console – Create Dynamic rss.xml file in progressive web app

I have a progressive web app in angular-8 and whole project is based on MEAN stack and deployed over google cloud platform instance.

Code is built and it’s dist is deployed on that instance.

I have applied for google news and it is approved. To show new stories in the google news rss.xml file should be updated with that new article’s details.

But problem is that when rss.xml is live within angular project and running on server how can I update that file with new article’s details?

Please help.

web crawlers – Is it legal to use the APIs of Meetup.com, Eventbrite etc, to aggregate their event data into one place, similar to Google?

I have a predicament. I’m trying to build a platform that will basically be a place where all events, online/offline, are listed.

Initially – my platform will obviously have zero events, because nobody knows about it. And for anyone to use it – there needs to be events on there – classic chicken and egg scenario.

My thought was to aggregate events on to my platform (and link to their source), whilst also allowing users to create events on MY platform. Eventually, I’d be able to not bother listing events from other sources if mine gains enough traction. So, I am definitely competing with these sites.

Google is pulling data from many different events sources, and displaying it on their pages like so – https://www.google.com/search?q=events+in+london+meetup&rlz=1C5CHFA_enUA720GB740&oq=events+&aqs=chrome.0.69i59l3j69i60l3j69i65l2.4289j1j9&sourceid=chrome&ie=UTF-8&ibp=htl;events&rciv=evn&sa=X&ved=2ahUKEwiYtuPx2bLuAhU3REEAHaRkCZ0Q5rwDKAJ6BAgNEA4&sxsrf=ALeKk03Uj9jeI8lTj0__V-UWcgcv_pdFew:1611427139353#htivrt=events&htidocid=L2F1dGhvcml0eS9ob3Jpem9uL2NsdXN0ZXJlZF9ldmVudC8yMDIxLTAyLTAzfDE2ODA2NzEwNzgyNjAxNDg4MTQ2&fpstate=tldetail

The difference is, Google, I assume (?), is probably scraping the data rather than using APIs.

In the Meetup API Terms, it states:-

“Not use the Meetup API for any commercial purpose without the express written consent of Meetup;

Not undermine our commercial interests or make unreasonable commercial uses of the Meetup API, such as by substantially replicating our Platform or significant aspects of the Platform, to be determined in Meetup’s sole discretion;

While you may charge for any application you develop (subject to Meetup’s consent), you may not sell, lease, or sublicense the Meetup API;”

I know aggregating is a bit of a legal grey area but I wanted to ask for opinions on whether or not this would be legal, and if not – how the hell do I get any traction and users without having any content?

What’s the best way to upload a million row spreadsheet as Google spreadsheet?

Google Sheets has hard-and-fast limitations. One of them is that no spreadsheet may have more than five million cells total among all sheets/tabs. If you are trying to upload 1M rows, and those rows each contain more than 5 cells each (which is likely), you’ll have exceeded this number (in fact, 1M rows with 5 cells each completely maxes the space limitation).

The is currently no workaround, no way to “buy more space,” etc.

I have been working with spreadsheets since they were first introduced to the world, and I have yet to see a case where 1M rows in one sheet was necessary. It almost surely points to keeping information you don’t need or grouping together information that would best be divided/subdivided into more meaningful chunks.

By way of a simple example, suppose you had 1M rows of data corresponding to customers who bought products. Did all 1M people buy these products in the same year, or could you have separate spreadsheets per year? Did they all live in one state, or could the data have been separated to different spreadsheets by state?

You can then make dashboards that can pull from other spreadsheets to show you what you want to know. For instance, if you separated data by year into different spreadsheets, you could have a dashboard in a different sheet that could access all spreadsheets from all other years to show you customers from the last three years who live in Florida (or who are age 30 – 50, or who bought more than five items per year, etc.).

Another thing to consider. It sounds like you’re currently using spreadsheets more as a database or databank. And while spreadsheets can and do serve this purpose, if you will have massive amounts of data, you may want to look into database tools specifically designed to handle that volume and then integrate those with Google Sheets for further processing.

google chrome – How to load a website with minimal internet speed?

I use Duolingo daily but sometimes my quota is over before the end of my internet subscription so I get throttled to 256kbps (kilobits not KBs) and this makes it nearly impossible to use the Duolingo website. Ideally I want to load the website with no styling (but keep javascript so that it can fetch the lessons) to be able to use it on my very slow internet. Also disable anything that consumes more speed that isn’t necessary to just see the text body of the lessons.

Is there any way to do that?

How to make Google sheets refresh date filtered pivot tables when a day passes?

Google Sheets has a nice advantage over Excel – their pivot table automatically refresh, while Excel’s pivot tables rely on clicking a manual UI refresh button (or – if the right pivot setting is changed from its default state – by reopening the relevant file).

But Google Sheets’ pivot tables do not get refreshed in certain cases.

If you turn this data into a pivot table:

Name Date Value
Foo =RANDBETWEEN(today()-1, today()) 1
Bar =RANDBETWEEN(today()-1, today()) 2

And add a date filter of today:

Pivot table filtering today

Let’s say luck has it that on the original run you get:
| Name | Date | Value |
| ——– | ————– | – |
| Foo | =today() | 1
| Bar | =today()-1 | 2

Then until the end of days you’ll see Foo in your pivot table, unless you change something else of course.

That’s because Google Sheets’ pivot tables don’t recognize the change of days (when the clock spins and yesterday becomes today, in this case).

Is there a way around it?

Rename multiple files in google drive from a spreadsheet

I have this spreadsheet which contains the name of multple files in my google drive
Column one contains the current names of the files and column two contains the new names i want to assign to each file

Using google app script i could do this manually by copying the old names one after the other and replacing it with the new ones

But now i want to grab each file from the drive and compare it with the current names on the spread sheet and which ever line it matches with i want to rename the file with the value of the new name column of that line

I dont know how to go about this

google sheets query – Combine two separate, working queries

Trying to combine two separate, working queries, so both can be used on a single sheet.

The idea is a User selects Data for a Resource (sheet TAB), and then either: a Region (Column D) or a County (Column H). Both Region and County are Drop Down lists.

These are the Queries that work separately:

=QUERY(indirect(B2&”!A1:H20″), “SELECT * WHERE 1=1 ” &IF(A2=”All Counties”, “”, ” AND (D) = ‘”&A2&”‘ OR (D) = ‘All Counties’ “),3)

=QUERY(indirect(B2&”!A1:H20″), “SELECT * WHERE 1=1 ” &IF(C2=”All Regions”, “”, ” AND (H) = ‘”&C2&”‘ OR (H) = ‘All Regions’ “),3)

Working Queries are on the first 2 TABs of this sheet

I have tried to join them:
={QUERY(indirect(B2&”!A1:H20″), “SELECT * WHERE 1=1 ” &IF(A2=”All Counties”, “”, ” AND (D) = ‘”&A2&”‘ OR (D) = ‘All Counties’ “),3); QUERY(indirect(B2&”!A1:H20″), “SELECT * WHERE 1=1 ” &IF(C2=”All Regions”, “”, ” AND (H) = ‘”&C2&”‘ OR (H) = ‘All Regions’ “),3)}

Also tried a few things like this with various syntax changes:
=QUERY(indirect(B2&”!A1:H20″), “SELECT * WHERE 1=1 ” &IF(A2=”All Counties”, “”, ” AND (D) = ‘”&A2&”‘ AND (C2)=”-” OR (D) = ‘All Counties’ ” AND (C2)=”-” OR C2=”All Regions”, “”, ” AND (H) = ‘”&C2&”‘ AND (A2)=”-” OR (H) = ‘All Regions’ AND (A2)=”-” “),3)

Also tried similar to above, but used ISBLANK(C2) type syntax.

Thank you for taking the time to try and help!

MASSIVE AUTHORITY 50 HIGH QUALITY 40 PR9 + 10 EDU. GOV Backlink For Improve Google Ranking for $9

MASSIVE AUTHORITY 50 HIGH QUALITY 40 PR9 + 10 EDU. GOV Backlink For Improve Google Ranking

MASSIVE AUTHORITY 50 HIGH QUALITY 40 PR9 + 10 EDU. GOV Backlink For Improve Google Ranking

Higher Ranking With Massive High Authority Backlink

We Do Here Manually 40 High Domain Unique Backlink + 10 EDU/GOV MASSIVE BACKLINK For Increasing Google ranking.

Our Work Full Manuall. With White Hat Method.So It Take Just Short time For Increase Ranking Result.

What We Do:

#We Do Manuall 40 High Domain Backlink.

#We Do 10 EDU/GOV Backlink

#All Link Are From High PR9 Authority

#No Spamming Link

#Permanent Unique Backlink

#Anchor Showing Link

#Full Satisfaction Service

#Details Report Send With Excell Sheet With Full Log In Report

#24 Hours Customer Support




What I Need From You:

#Website URL

#Keyword

★We Accept All Kind Of Website Without Porn Adult.

★We Accept Maximum 5 URL Unlimited Keyword

★We Accept Non English Content

Please Buy And Get High Position On Google

.