At work we use google workspace. It is a paid service, but gives a lot more space + shared drives. Although I have to say that I work in manufacturing, not in game dev. We use it to share documents, project files like CAD models and stuff.
This is incorrect; if google drive is correctly configured it can and does meet security and audit requirements of most large enterprises, and in fact is better suited for auditing than many other options that enterprises insist on using. This starts with marketing spiel, but I'm sure you can google for the workspaces docs you need to learn more.
Yes.
It`s possible to get unlimited storage for Google Drive at very cheap prices. You can buy a domain, and link it with Google Enterprise. While it may show that there's only 5TB for $18 a user (and further plans show you have to contact them), once you sign up you will see there's a Payment portal with Google Workspace Enterprise standard with Unlimited Storage as an option for $20 a month for a single user. Google Drive's main downside is that it has an upload limit of 750GB/day. Other minor downside is you can only download 10TB/day. This makes it the most practical option for most datahoarders.
I also recommend using Adveronix, it's a Toolbar Addon for Sheets, which lets you pull data from Google, Facebook and many providers, visually and pretty straightforward.
https://workspace.google.com/marketplace/app/adveronix/523964251627
im not affiliated with them in any way, but its so usefull you'll thank me foreva.
I sometimes need to send texts out to hundreds of people as part of event coordination I work with. Used to take me forever and I'd make mistakes until a few months ago I started using a Google sheets extension that just instantly sends texts to everyone on my list with all of their individual information automatically included. Saves me hours per week honestly.
edit: this is the one. us & canada only it looks like fyi
don't look at it as only google voice. put it in an office package in a business context. and that is what google has been doing for some time now. we on the personal-use side get the benefit for free. but use any of the google services in a business, then there is the paid version of Google Workspace aka Google for Business -- that's where google makes money with a comprehensive office cloud business package which includes google voice but for business purposes -- just think office online package of services which of course include phone lines, namely lots of google cloud services being used in the office including google voice lines -- and of course business customers pay for it all with all that
to get some sort idea as to $ numbers, go see: https://workspace.google.com/pricing.html
There should be 2 ways of handling this, depending on your app.
Either you handle writing to Gsheet using the Sheet API. It can be complicated here cause you'll have to handle which spreadsheet to write to, depending on user amd your FE workflow... can be tedious!
Or you use - what seems to be the go to solution for this kind of case - Google App Script and make a macro that the user can run from Gsheet to extract the data.If you need more flexibility you can even make an "Add-On" and build a form so that user can extract what they need from the database
I would also recommending looking for existing vendors that built this kind of "Connectors" for Gsheet like https://workspace.google.com/marketplace/app/api_connector/95804724197
There's also an add-on for google docs known as Writing Habit that offers statistics for your writing (when turned on), including word count.
Here's a link: https://workspace.google.com/marketplace/app/writing\_habit/908529024908
For creating the structure i just recently developed an google-sheets extension that lists all headings of a list of urls into an overview. So you can quickly get an overview of the already ranking articles and then build a better structure based on this info: https://workspace.google.com/marketplace/app/nicheknife_content_analyzer/136984433266
its obviously free and i build it more or less for fun..
If you check out their terms, you'll see that the 5 user limit still exists and none of the new ones actually include unlimited data anymore.
So while it still works (as demonstrated by you and a number of others), it isn't really official anywhere.
Here's my advice: don't get rid of Gmail/Google yet.
Wait, don't leave! Let me explain: if you set up a custom domain and pay $6/month for Google Workspace you've already covered the first 80%. You can move your email somewhere else and Google won't snoop on your data (many Fortune 500 companies use Workspace/GSuite, their policy is clear, they don't use Workspace data for advertisement).
But let's say you don't trust Google one bit. You can use encrypted email for sensitive communication and set up IMAP and Cal/CardDAV clients on all your devices (and even on a server you own) so that in the worst case you have a full backup of your email, contacts and calendar.
What about files, notes and stuff? I personally use a combo of Drive + Joplin (an open source note taking app with E2EE, similar to Evernote). Everything I have is available at all times on at least 2 devices + Drive itself. There are even tools like InSync that convert GDocs files into Open/MS Office formats automatically for complete offline access.
The advantages are clear: you still own your data (and encrypt what you really want to keep secret) and you still use the undeniably amazing Google products. At the same time you are free to browse for alternatives if you really want a hardcore anti-Google solution.
And if you have Apple devices you can easily set this up to be multicloud. Have a copy of everything on both iCloud and Drive (with Joplin allowing you to still encrypt things end2end).
Just my 2 cents.
Der findes en udvidelse til Google sheets der hedder Yahoo Finance fra webdatahub. Det virker ligesom Googlefinance og understøtter det Google Finance ikke gør. Jeg ledte længe efter det, nu kan jeg endelig bruge sheets til at tracke hele min portifølje. https://workspace.google.com/marketplace/app/yahoofinance/881284038348
...you do know that Google does not do any kind of data collection on GSuite/Google Workspace customers, right? https://workspace.google.com/learn-more/security/security-whitepaper/page-6.html
The only thing they "collect" is basically just for spam filtering, virus detection, spellcheck and the ability to search, and all of that is only for that specific Google Workspace customer. Not for the general public, and not for other Google Workspace customers. None of that stuff is ever used on anyone else's account but your own, and even then, it's for individual users. Bob from accounting isn't going to start seeing spellcheck results from Hannah in development.
GSuite/Google Workspace is not the same thing as free Google services.
>Essentials plan
Where are you seeing Essentials plan as a response? The product looks to have been around for a good while but it's targeted at those who have corp email IDs already:
https://workspace.google.com/essentials/
It's no answer for the family gsuite accounts where email is the primary application.
I suppose you tried this extension and it didn't work well enough. Either way, having a stable repository is a good solution. Might be worth getting the link in the community spreadsheets part of the subreddit wiki. If you send a modmail they'll add it. That page needs some updating now that I look at it.
IT guy here if you don’t have a domain name you will need to use email hosted by someone else on their domain name like gmail. If your willing to buy the domain name now you can set it up so that gmail is actually hosting the email but the customer uses your domain name to email you. You don’t have to actually buy or put up a website yet just purchase the domain.
See below.
Customers that have 5 or more End Users will receive a total amount of Google Drive storage equal to 5TB times the number of End Users, with more storage available at Google's discretion upon reasonable request to Google.
We use this free google sheet plugin
https://workspace.google.com/marketplace/app/adveronix/523964251627
That pulls data from fb and google ads
Wax lets you run Python right from Google Sheets, nothing to install or download to your machine, just add it from the marketplace.
That is demonstrably wrong https://workspace.google.com/terms/premier_terms.html
​
>5. Intellectual Property Rights; Protection of Customer Data; Feedback; Using Brand Features Within the Services.
5.1 Intellectual Property Rights. Except as expressly stated in this Agreement, this Agreement does not grant either party any rights, implied or otherwise, to the other's content or any of the other's intellectual property. As between the parties, Customer owns all Intellectual Property Rights in Customer Data, and Google owns all Intellectual Property Rights in the Services.
If they did steal your IP you can sue them for breach of contract and losses. What you're proposing is just downright paranoid and belongs within the realm of conspiracy theories.
1- Compra o dominio no registro.br ou Godady
2- Usando o gerenciador de DNS do registrador acima, aponte o www para o IP do seu site hospedado
3- Aponta o mailserver do DNS pro seu provedor de email. O google tem um procedimento próprio pra verificar se você é o dono de verdade do domínio.
2- Se o site estiver no RasPi, tem que tem um IP publico fixo e exposto, o que vai depender do provedor. Não tenho 100% de certeza que dá pra contornar isso usando DynDNS. E tem a questão da banda de upload. Provedores sacam na hora que voce tá hospedando site e podem te cobrar por isto.
3- Mas sinceramente, a não ser que você queira mesmo aprender na marra a fazer a hospedagem localmente, pague por uma hospedagem de site. Tem dúzias por aí.
4- No fim, se você criar o dominio direto no Google tudo fica mais simplificado, porém talvez mais caro
PS: Nem tente fazer hospedagem local de email. Até dá pra instalar e configurar, mas as grandes empresas (google, MS) vão te ignorar e não mandar/receber email se você não tiver certificado digital autenticado e reconhecido por eles como sendo fidedigno.
Either. You can use gmail for business, it's $7.80 per month per user. https://workspace.google.com/intl/en_ca/solutions/new-business/ There are other services too like zoho, fastmain and dreamhost.
Or you can setup your own server and run everything yourself, which is a lot cheaper. I have <mylastname>.com and run a server for all my family and give them email. Only cost me about $20 / month.
Most large companies will run their servers themselves, they don't want to have to rely on another company. Most small companies would use a service.
I setup my mail server around 2000 when it was easy. Now it is hard, since everybody will assume you are a spammer and block your email. My server has been around so long that it is "trusted".
That's quite the assumption seeing as how you have no details of how I used the account.
Tell me this, how would you interpret their terms of service regarding suspension?
4. Suspension.
4.1 AUP Violations. If Google becomes aware that Customer's or any End User's use of the Services violates the AUP, Google will notify Customer and request that Customer correct the violation. If Customer fails to correct the violation within 24 hours of Google's request, then Google may Suspend all or part of Customer's use of the Services until the violation is corrected. Suspension of the Services may include removal or unsharing of content that violates the AUP.
4.2 Other Suspension. Notwithstanding Section 4.1 (AUP Violations), Google may immediately Suspend all or part of Customer's use of the Services (including use of the underlying Account) if (a) Google reasonably believes Customer's or any End User's use of the Services could adversely impact the Services, other customers' or their end users' use of the Services, or the Google network or servers used to provide the Services; (b) there is suspected unauthorized third-party access to the Services; (c) Google reasonably believes that immediate Suspension is required to comply with any applicable law; or (d) Customer is in breach of Section 3.3 (Restrictions) or the Service Specific Terms. Google will lift any such Suspension when the circumstances giving rise to the Suspension have been resolved. At Customer's request, Google will, unless prohibited by applicable law, notify Customer of the basis for the Suspension as soon as is reasonably possible
Is it reasonable to believe that if I did do anything wrong, I would be given notice, a warning of suspension, and lastly a path to reinstate the account should I remedy any issue?
Because after suspending my account, Google ghosted me and gave no further support.
https://workspace.google.com/intl/en_ca/pricing.html
I don't see unlimited anything..
Business Starter.. 30GB/user
Business Standard.. 2TB/user
Business Plus.. 5TB/user
I use voip.ms. It's for the more technically inclined (it's basically a PBX in the cloud), but if you're somewhat nerdy, you should be able to cope with it.
​
Also, Canada is actually one the dozen or so countries GV is available in (https://workspace.google.com/terms/service-terms/voice/regional\_terms.html), just not the consumer account version that's only available in the US.
> Wer würde seine Hand ins Feuer legen, dass ein externer Dienstleister nicht auf die Idee kommt die personenbezogenen Daten auf illegale Weise weiterzugeben oder zu verkaufen?
Google. Es ist DSGVO-Konform alle Verarbeitungsaktivitäten an Dritte auszulagern, wenn sie vertraglich gebunden sind die Daten nicht für eigene Zwecke und nur wie angewiesen zu benutzen. In diesem Vertrag sind auch Sicherheitsvorkehrungen geregelt. Dass einzige was nicht ausgelagert werden kann: die Verantwortung.
Die meisten Datenlecks sind nicht wegen “upps, unser Auftragsverarbeiter war böse und hat unsere Daten auf dem Darknet verhökert”. Meist sind das verständliche Sicherheitslücken wie die Fehlkonfiguration von Backup-Systemen, gelegentlich auch das Teilen von Daten mit Dritten die keine Auftragsverarbeiter sind – das war bspw im Cambridge Analytica-Skandal der Fall.
> Wer sind diese externen Dienstleister überhaupt?
Google ist nicht verpflichtet sie namentlich aufzulisten. Für ihre Business-Produkte wo Google selbst als Auftragsverarbeiter auftritt haben sie aber eine solche Pflicht. Bzw sind hier die Unterverarbeiter für Google Workspace. Youtube's Altersverifizierung ist aber nicht Teil von einem solchen Produkt.
Connected my Google Sheets to this API Pipeline Add-On . from there it depends what feeds you like to get into your sheet. from the description the author listed the following
​
CoinGecko, Binance, Ethermine, CoinMarketCap, CoinBase, MinerStat, FlexPool, CoinAPI, BitPay, BitStamp, BitFinex, Ethereum, CryptoCompare, CoinSpot, Cryptometer, SupportXMR, Poolin, Nanopool, Ethplorer, CryptoWatch (CryptoWat.ch), PancakeSwap, BitKub, IndoDax, KuCoin, Coin Paprika, Nomics
Do you pay for Google Workspace? Personal or otherwise? If you do, you can refer to section 5.2.2 in the following document where they do mention advertising
https://workspace.google.com/terms/dpa_terms.html
Closest I could find ;)
I have used this tool about 15,000+ (seriously) https://workspace.google.com/marketplace/app/form_publisher_form_to_pdf_google_docs_t/827172627657
It actually lives on in the corporate world. It was initially called Google+ for G Suite but is now called <em>Google Currents</em>.
Not the same look and some new/changed features, but the heart of Google+ is still here with user profiles, posts, comments, etc.
> But their tos is very clear it is 1, 2 or 5T per user.
Gsuite Business (the "normal" one) 5 user is still unlimited with no small print . Which makes it kind of shocking each time when I see somebody bragging about "upgrading" to Workspace Enterprise that's more expensive and with more small print.
You're showing Enteprise Standard, yep that's the one: https://workspace.google.com/terms/user_features.html
Actually it's even worse, it's 1TB/user if you have less than 5 users:
"Customers that have 5 or more End Users will receive a total amount of Google Drive storage equal to 5TB times the number of End Users, with more storage available at Google's discretion upon reasonable request to Google. Customers that have received a Google for Nonprofits discount or have 4 or fewer End Users will receive 1TB storage in total for Google Drive, Google Photos, and Gmail combined for each End User."
>-Create free workspace essentials acct https://workspace.google.com/essentials/ add each user (use their email alias) to team account as member, main acct as manager.
>
>-Create cloud identity for each user
At first glance, I would have thought it would have been one or the other rather than both.
What's the thinking for having both of these for a single user?
Thanks!
It's definitely possible, but blended data is prone to having issues.... plus it's hard to see exactly what you are trying to do.
I'd recommend the Google Analytics for Sheets add-on as a better solution. You can create your reports and combine them together in sheets, and then connect Data Studio to sheets directly. This avoids having to blend anything and should work more reliably.
Totally understand that concern.
Here's out Data Security Policy and Privacy Policy. Additionally, you can see our very high rating and nearly 40k installs on our Marketplace page, for what that's worth.
Specifically what you're asking for:
"Coefficient sits on top of your data source systems. When the Coefficient application extracts data on your behalf, our servers make live API calls to your cloud data sources (e.g. Salesforce) and perform live queries directly against your databases. We never store copies of your source data on our servers.
In our databases, we store only the necessary metadata about your source systems that allows the Coefficient application to import your source data into your Google Sheets documents. When a user is configuring or running a data import, some data might be temporarily cached, but only for the duration required to complete the desired operation."
Don't hesitate if I can offer anything else.
Yeah, I've been looking at solutions as well and thought I had one (https://workspace.google.com/marketplace/app/workspace_recommendation_tool/598861787178) that I could use, but it was limited to free 1 sync license and then when I inquired about more licenses they said that the only way to get more licenses was to purchase full Workspace licensing from them. I have a huge 300K+ emails account that has been syncing using their tool all week to the Gmail account I setup.
I'm now looking at trying to setup a docker instance of imapsync, in the cloud, to do some additional transfers but this isn't going to help all of my less technical extended family that is all over the U.S. I've been considering telling them all that their only solution is to download a Google Takeout backup and just start fresh. It really sucks all around that's for sure. You'd think that Google could provide a no brains tool to transfer between their own services.
Ema aside, which seems like the easiest thing in the Google ecosystem to handle, I feel screwed on all of the other services. I still haven't found out how I can migrate many GBs of Drive data to a Google account. Simply sharing the Drive data to the Gmail account still gives me no way to transfer the ownership. I'm finding that the same problem exists in Google Keep. I can share a note but I have no ability to change the ownership and have to resort to copying the notes each manually to my Gmail account and then removing my access to the original note in the Google Workspace. What's stupid is that Google does low my to change the ownership of Calendar meetings from a Workspace account to a ail account. Their consistency in this regard is ridiculous.
The primary difference between the Waffle and the Dashboard link is that the Dashboard adds a section called "Approved Apps" which shows all the Google Marketplace add-ons and such that we allow all users to install as desired. The "Your Apps" section at the top seems to match what's in the Waffle.
Thanks for the link, but it's a separate issue. The App Launcher shows the specific Chrome Web Apps that the user has installed, and is distinct from the Waffle. The primary issue for getting the waffle URL is that students use it to get to the SSO page for some of our online curriculum stuff (eg. Savvas and McGraw Hill content). But until we figure out what that waffle URL is, we'll just direct students to the workspace.google.com/dashboard link instead which will get them to the same place.
This is what "unenforced" means, it doesn't bother in your user account. Look at your localized https://workspace.google.com/terms/user_features.html and see what says there for your specific plan. Especially you find any unlimited Workspace it'll be extremely interesting.
No.
Gmail is a secure email service that meets HIPAA, PCI and various ISO standards. It also complies with various privacy laws such as GDPR and California CCPA. Your data is not being sold or made public.
https://workspace.google.com/security/?secure-by-design_activeEl=data-centers
There are a bunch of apps that will automate posts and images but may cost a few bucks per month though like dbaplatform. You can also check this free script out. Maybe you can check out the code to see how it works if it doesn't do exactly what you need.
Google Drive is free, of course, but Google Workspace is also pretty cheap (e.g., $6-18/month). I think they negotiate pricing for enterprise, and probably have discount options for government/non-profits. That said, most of the features you mention, like file scanning, cloud storage, shared document editing, can all be done on the free version.
I get you on privacy, but privacy means cost.
GMail Workspace (formally G Suite) is GMail with privacy and self ownership.
Also, I stand corrected. Here is there pricing per month.
Your spam is going to be filtered at the server, not the client. GMail is the king of spam filtering. If spam filtering is important, go GMail. Or go with another paid service. Or... use GMail free and pay with getting scanned.
Tinha a mesma questão que tu e encontrei a solução neste add-on.
Uso só para tirar os preços e às vezes demora um bocado a atualizar o documento quando abres, mas tirando isso funciona às mil maravilhas.
Em relação ao que dizes sobre a função googlefinance dar um preço diferente da DeGiro, também me apercebi disso quando montei o meu ficheiro, mas na altura achei a diferença irrisória para o propósito do ficheiro (ter uma visão geral e conjunta de todos os meus ativos)
There is a catch, you need a domain name to be on Gsuite (Business Standard) and google imposes a limit of 750GB upload per day and 10TB download per day (this can be avoided using autoRclone). If you need any help or got any question feel free to ask.
Squarespace has nothing to do with it, unless you got your domain through them and then they are your domain registrar so you'll have to set up the DNS through them.
It's not a "regular" Google account like your Gmail. Go here to sign up and start set up.
>Database.... there are 54 entries with about 10 properties each.
If these entries are not changing very often then you dont exactly need a database. You could just hard code them in a JSON array that javascript can understand. If I understand what you want that would create an array of 54 objects with each object having up to 10 properties each, which isn't that huge.
Whenever I've done stuff like that I find an easy way to create the JSON is to do the data entry in a google docs spreadsheet, then you can use an addon like this https://workspace.google.com/marketplace/app/export_sheet_data/903838927001
to export the data to a JSON array that you can just copy and paste into your javascript code somewhere.
Why are you comparing GCPW to MS InTune? GCPW is an credential provider for Windows so users can login to their Windows PCs with their Google credentials, while InTune is an endpoint management platform. You should compare InTune to Google's Endpoint Management Platform: https://workspace.google.com/intl/en/products/admin/endpoint/
My add-on is useful for Google slides users. https://workspace.google.com/marketplace/app/keypoints_google_slides_addon_ai_powered/331682014610
I am trying to sell it to education and classroom customers using workspace.
As you said, I should shortlist the top users using classroom and pitch them my add-on.
Thanks for guiding.
I'm researching map-pinning functionality/integration too... looking to use it for the purpose of dispatching employees, to make it easy to optimize routes visually. Currently we use Google Sheets + Mapping Sheets—best combo we've found for the job. But would love to find a way to move to Notion...
Use a Google Form to collect the scores. You could even use the FormRanger add-on to keep a drop down list populated with agent names / IDs.
Ah, okay. I guess I'm only paying for one email address at the moment.
Yeah I'm seeing that here: https://workspace.google.com/pricing.html
What I'm also seeing is that you can have "group aliases" which don't cost extra. The examples are "sales@yourcompany" and "support@yourcompany". Maybe this will work for OP?
Still unlimited on my old $12/mo too, OP just got "lucky". But it looks like a new plan $20/mo enterprise user got the same treatment. And their terms spell out pretty clearly how it could be, so it seems likely that is the future.
It seems pretty reasonable for them to do it in waves though. Fingers crossed, but I think anyone doing this should be prepared for a future where they can't add to it and then year-ish later it gets removed.
https://workspace.google.com/terms/education_privacy.html
With Google Workspace for Education administrators. Google Workspace for Education administrators have access to information stored in the Google Accounts of users in that school or domain.
Device no, google account yes.
There's a ton of them out there that will do it in Sheets: https://workspace.google.com/marketplace/search/mail%20merge
When you say "Outlook" do you mean from an at outlook dot com email address (sorry if that's a stupid question)? I think most of them on that list will send it via your GMail / G Suite account. I run Mailman (open source) and we just have Gmail / G Suite but we could certainly add other email providers to it.
I think workspace in its TOS say that if you use their stuff with a workspace account Google will not process data for advertising purposes or serve advertising in the services.
Do I believe them? Not really, but anyway they say that with a premium workspace account your data are not used for ads and you don't get any ads at all in their services.
If you want to do it yourself, any computer with some upgraded hard drives can run Nextcloud. Which is DIY cloud storage, with desktop and mobile apps to handle syncs, like drop box. It also has enterprise features such as granular permissions and LDAP/AD (I think) authentication.
If you want something more turn key, Google Drive File Stream does the same thing as part of Google Workspaces and comes with a bunch of other useful features.
If you plan on going the DIY route and want to host your own server. I would advise against a RPi. Enterprise storage and workloads are a different beast. At least get a hard drive rated for NAS work (WD Red), or ideally a data center drive (WD Gold) if you are going to be doing heavy use. If you are comfortable, consider getting an actual server. You can get good deals on quality used servers with all the enterprise features you didn't know you needed (until you need them), like server grade hard drives, hardware raid, and multiple processors.
TL:DR Nextcloud is like dropbox that you run on your own computer. As long as the pc is accessible from the internet (or local network) it will handle the networking and authorization.
GAM + a pivot table perhaps. But this would be static, the export represents a snapshot in time.
I don't think it's what you're looking for but this simple Groups Directory service can be handy. https://workspace.google.com/marketplace/app/groups_directory/378383824115
I can input a User and get a list of all their Groups as one example use case.
No problem. This might be a setting and not exactly a new service, so I may have provided information not exactly related to the issue at hand. Either way I'm glad it was helpful nonetheless. Since March (COVID), Google has pushing new stuff more than ever. I signed up to get email alerts so I can be in the "know". I think I signed up from this page: https://workspace.google.com/whatsnew/product-updates/
We have the Google Dashboard set as the home page for all students. This page allows students to access almost all of our web-based curriculum programs using Google SSO.
https://workspace.google.com/dashboard
On the top of that page, there is an option on the top right to add an admin message. This would then display that message on all of the Chromebooks on that particular page. We've never actually done it, but it's there.
I don't know of a way to send a message that overrides the user's screen, so they'd have to be on that page to see it.
Hey I remember this post! That's what /u/dreadstar22 wrote, and my comment become <strong>top comment</strong> there!
But on a serious note, OP, it helps to know what your territory's specific demand for IT is. Like I wrote in the linked comment above, I worked in IT in Arizona and then in California and those two IT landscapes are way different. California especially Los Angeles / San Jose is all about cloud migrations and cloud optimization but Arizona (at the time I lived there) was 100% on-prem and at the time very much waterfall with minimal agile -- so it was pureplay basic infrastructure operations with some scripting -- Arizona's just starting to shift into a mostly Azure landscape with AWS and GCP coming in for seconds -- e.g. <strong>State of Arizona uses GSuite</strong>, but not traditional GCP infrastructure offerings like Compute Engine. And Azure has a <strong>GovCloud region in Arizona</strong> spun up basically right after I moved away in 2017.
Cuz, at the end of the day, you don't want to learn all Azure if the territory you're looking for jobs in is all AWS, for example. So really know your territory.
In the past, I assumed they were under the GSuite business which would be unlimited space per user. Now that Google changed it to Workspaces, the limit may be anywhere from 2TB to unlimited still. I'd be curious to hear as well as I am under 2TB.
How many times will people claim they are losing unlimited storage...
It`s possible to get unlimited storage for Google Drive at very cheap prices. You can buy a domain, and link it with Google Enterprise. While it may show that there's only 5TB for $18 a user (and further plans show you have to contact them), once you sign up you will see there's a Payment portal with Google Workspace Enterprise standard with Unlimited Storage as an option for $20 a month for a single user. Google Drive's main downside is that it has an upload limit of 750GB/day. Other minor downside is you can only download 10TB/day. This makes it the most practical option for most datahoarders.
based on this https://workspace.google.com/terms/standard_terms.html Google only has to give you 30-days notice should they decide to stop offering the service.
Oopsie daisy. It seems Google just closed this juicy "loophole". It used to be that you can buy Business subscription to G-Suite for 5 users and get unlimited storage; de-facto the 5-user requirement was never enforced, so you could have got unlimited storage for just $13/month. And yes, it was too good to be true, and yes, many people took advantage of it.
Now it seems they changed things quite a bit, Renamed G-Suite to Google Workspace and unlimited storage option is now gone. Hardly surprising but not unexpected. Nothing unlimited at fixed price is sustainable.
https://workspace.google.com/pricing.html
While I'm sure existing users can keep using it -- but new users are out of luck
Sorry for misleading you, it was a surprise for me.
I have a similar Google Sheet set up for TRT, using Timecode-Magik's extension:
https://workspace.google.com/marketplace/app/timecodemagiks/503934260838
However I'm not sure it does DF timecode. You might need to use 30 NDF and then multiply the result by 1000/1001 to get 29.97.
Hey, I do freelancing for Google App Script based projects. $20-$30 per hour.
Recently created a add-on to manage hiring using Google Sheets
Hey,
I was in the same situation it just took me forever to translate the text on each slide with Google Translate.
It was really annoying so I created a small add-on to do it automatically: https://workspace.google.com/marketplace/app/slide_translato/672875861603
It is not crazy, it basically automatically retrieve the text on each slide and translate it in a new slide deck.
Pretty simple but I am saving a lot of time thanks to this tool since this is something I need to do pretty often!
Hope it can help you too :)
Mike
I've used JotForm for quite a few use cases in the past and they have a built-in Slack integration that allows you to customize the message that is sent in to a Slack channel of your choosing.
What's nice is you can use the specific form fields as variables in your Slack message. Free plan is limited to 100 submissions p/mo though - I know they offer a 50% education discount on paid plans though and it's a pretty useful tool.
Could set up a simple form for parent submissions with child's name and individual picking up and have those individually sent into a channel message (ie. "{Child} is being picked up by {Parent}". Obviously this would need to be set up to comply with your own policies/needs but just as an example of how it could work.
I've seen this Google Forms add-in as well but no experience using it (https://workspace.google.com/marketplace/app/slack_notifications_for_google_forms/451493071820).
Otherwise, form submissions to Google Sheets as others have suggested and might be able to set up an in-channel notification through the Google Drive integration.
The personal use GV is fine for one person businesses, but given your use case, if you do use GV, make sure you sign up for the actual business service.
Please note, if you aren't already using Google Workspace, GV may not be the cheapest solution, since it requires you have Workspace licenses as well. This is doubly so if you want to use an auto-attendant to answer calls, which means you'll need a standard instead of starter license.
https://workspace.google.com/intl/en_ca/products/voice/
Also, Texts can't be transferred between users in GV, nor can Auto-attendants . Generally SMS with GV isn't a great experience, but that's true of any VoIP phone service..
That said, with those caveats, given your use case, GV is actually a pretty good choice for cases like yours, since it also has calendar integration and multi-device ringing. If you can make use of other Workspace products, all the better.
I would definitely recommend improving the bandwidth issue with a service like Starlink if at all possible. Otherwise video is going to be bad no matter which service you use. I believe Starlink actually work best in low density areas.
As far as ease of use, long duration video calls, security, guaranteed service, and the ability to work on many devices , I would look at Googles Paid offerings. They detail flexible price schedule here and if this is non profit oriented there may be even better pricing. https://workspace.google.com/pricing.html
I also really like how Google’s collaborative documents work from my own experience.
Hey, windsor.ai does exactly this. there is a google sheet extension which is pretty easy to use.
https://workspace.google.com/marketplace/app/ad\_data\_and\_analytics\_by\_windsorai/258608024049
Setup Google Cloud Identity, link your Azure AD via SAML/SSO, add required users
Add Google Workspace licenses for anyone using Drive
The first one is free; you should do this anyways if you are working with a marketing team. That way you have some control over the accounts they are probably using for various Google marketing products like Analytics/Ads/Search Console/etc. Also check out Google Marketing platform if you need more fine grained access control for those services.
For the second step - the cheapest Google Workspace license is around $6 USD/user/mo. If your marketing staff insist on using Google Drive, then you can at least push them to use the enterprise version of it. No budget = not your problem.
Some additonal resources:
Google Cloud Identity Free vs Paid
https://workspace.google.com/intl/en_uk/pricing.html
Read more about it and see if it fits. There are other versions for each region.
You have to be a business, but I'm not sure what the qualifier is. Can business individuals sign up?
Google Workspace -- https://workspace.google.com/intl/en_uk/
Corporate and Government Enterprises don't like it when there is external data collection. That's partially why this exists.
Entities can control what data is collected.
I just published an add-on that converts a Google Sheet into Applicant Tracker where you can schedule meeting invites with web conferencing and send email updates to candidates. Welcome to try it.
I created it for my own small use case while hiring in a startup and continued adding features to it.
If you're already working out of spreadsheets, your best bet is probably to use a Google Sheets add-on like Coefficient (disclaimer - I work there). You can easily setup automatic imports and exports (ie writebacks to Salesforce), so if you have basic spreadsheet knowledge, you should be able to build in the logic to find the right fields (with VLOOKUPS, probably) and then flag which Contact records need to be updated.
Coefficient has a completely free plan you can use to do this, but you'll eventually have the option to pay for premium features like automations, slack alerts, etc. Feel free to DM me if I can help
We use the "Docs to Markdown" extension (despite its name, it converts to HTML too)
This only works for basic universal HTML formatting, so when we do things like color or size or font we go through and manually edit the HTML afterward. But if all you're doing is bold, underline, and italic, then this will cover you perfectly. (As an added bonus, it also gets past the "random extra spaces between formatted text and unformatted punctuation" issue that crops up with some other methods.)
Alternately, of course, you can edit the doc yourself in AO3's editor after pasting and before posting. Format directly in the rich text editor, or use HTML editor and wrap your text in <em>text</em>
or <i>text</i>
for italics, <strong>text</strong>
or <b>text</b>
for bold, or <u>text</u>
for underline.
I didn't find an easy and convenient solution, so I went back to the Google Sheets plugin and this time it worked for over a year. Just check up on it every so often to make sure it is still working.
They offer Google Workspace Essentials Starter: https://workspace.google.com/essentials/ If you host email separate, it may offer sufficient features for your use.
There are quite a few "mail merge" type apps that work with sheets. Here are two:
From the plan comparison page: https://workspace.google.com/pricing.html
Enterprise plan customers have 5 TB of pooled storage per user and can request additional storage if needed by contacting Google Support.
Da, există aplicații care se conectează la Google Excel și îți trimite notificare, chiar și lor dacă le pui email.
Am căutat că nu mai știam cum se numește: https://workspace.google.com/marketplace/app/magic_cell_notifications/886834937346
Eu am folosit-o de multe ori.
Docs can't do this unless you are prepared to learn programming with Apps Script. However there are 3rd party apps that can:
If you want to use an add-on: Merge Sheets & Docs
If you want to code it yourself: YouTube 1
Good luck!
For me, it depends on the trip. I use Planiversity for longer trips where I need flight, hotel, car rental, etc. info.
For short trips and weekend getaways, I use this Google Sheets template.
I don't know the prices in Europe. But Google Workspace – Business Plus can get you 10TB for under 40 bucks a month. The confusing thing is you have to add users, not storage space. It's 5TB per user, but that doesn't mean each user has a dedicated 5TB. If you have 4 users you can store 20TB for approx $80/month.
My 5 cents for this discussion:
list Google Drive free option in the web app https://movefiles.app or Google Drive add-on on the Google Workspace Marketplace.
Yes, you can transfer your own Google drive files to another Google Workspace or free account Google Drive: use this web application https://movefiles.app or the Google Drive add-on available on the Google Workspace Marketplace.
The latest Workspace pricing page says, "Enterprise plan customers have 5 TB of pooled storage per user and can request additional storage if needed by contacting Google Support."
So, when you need more, just request it.
Google Workspace is Gmail for business. It also includes their version of Office, and Drive for file sharing, and a bunch of other services. The important part is Gmail, which is what you say you want, and it will handle custom domains (provided you have admin control over your DNS - you have to verify you own the domain by creating a TXT record). Pricing starts at $6/month per user (presumably, you would only have one user - if you need multiple email addresses, you can add them as aliases to the actual inbox).
So what you've got is three different services:
Registrar to register the domain name DNS service to point that to the right place Email hosting.
I believe Google can provide all three services, but they are independent of each other.
It's called the Google Workspace Enterprise Standard plan.
You can find it here: https://workspace.google.com/pricing.html
It's the one that says "contact sales". Honestly, I moved from a GSuite plan back in the day (when they switched to the 'workspace' platform a few years ago). I was automatically migrated to the Enterprise variety of the plan without interacting with anyone in 'sales'. The cost for me (1 user) is $20/month. That includes unlimited Google Drive space. I have about 40TB, but have had as much as 90TB at times.
Might be worth just actually contacting sales and saying you only have 1 account, but need the functionality of Enterprise?
I think I tried that when experimenting with multiple Google Workspace add-ons
A couple others:
*https://workspace.google.com/marketplace/app/google_tasks_standalone/845259613276
Very far fetched. I don’t think they’re looking to create new free tiers for anyone. Especially not a free business product for families. Heck I only discovered last night that they even have an edition of Workspace for individuals (one man businesses). It lacks support for custom domains though. But does support bookings. So confusing. They overcomplicate things for everyone. I’d argue that the root cause of all our problems here is that Google doesn’t listen to or understand the customers. They are very good at creating new products, but often poor at execution. When it doesn’t immediately work out, the leadership changes and after years of poor support they give up and cancel it and make a new product to replace it. Rinse and repeat.
The method of cross-domain transfer with preserving file IDs using Google Shared Folders is well described: see for example here https://www.tabgeeks.com/tabgeeks-blog/how-to-transfer-ownership-between-domains-in-google-drive I have automated this migration process in my utility published on the Google Workspace Marketplace https://workspace.google.com/marketplace/app/transfer_files_ownership/631873519917 and also available here https://movefiles.app
with there being over 1.5 billion gmail accounts , there is no number to call if your email address ends in gmail.com nor any direct email or other type of direct tech support unless you pay for Google One https://support.google.com/googleone/answer/9004013?hl=en or Workspace https://workspace.google.com/individual/
https://support.google.com/googleone/answer/9269729?hl=en&ref_topic=9003736
I've used this app for mail merges. It can send emails with Drive attachments on a schedule:
Here's another one. I haven't used it myself but the guy who made it does a lot of Sheets tutorials and is probably legit.:
https://workspace.google.com/marketplace/app/mail_merge_with_attachments/223404411203
Det er det. Som jeg læser det er problemet dog ikke datasikkerhed, da Google allerede har bragt deres services i overenstemmelse med SCHREMS ii. Det kritiserede aftaletillæg er ændret d. 7. juli 2022.
Desværre betyder det nok bare i sidste ende der skal bruges flere skattekroner på jurister i kommunerne, i stedet for folkeskolens virke, med at danne fremtidens borgere.