How to find a Google Apps User’s Creation Date

Did you know that there’s an easy way to find a creation date of a user’s account in your domain for Google Apps for Work? Currently, the information of a user's last login date can be accessed within the Google Apps Admin console.

Please note that viewing the creation date of a user’s account is not yet available in the google apps admin console, but we will demonstrate elsewhere you can find a user account’s creation date can be found.

Here is how to view a user account’s first login date and a user account’s creation date.

How to Find a User’s First Login Date


Login to Google Apps Admin Console (http://admin.google.com) and go to Users > Click three vertical dot icon in the upper right corner > select Download users to download a csv file.




You can find a ‘First login’ column to see user’s first login date.



How to View when an Account was Created


Go to Google Apps Admin Console and sign in to the Google admin console. Please access the Directory API webpage in a new tab at https://developers.google.com/admin-sdk/directory/v1/reference/users/get 

Click the link called ‘authorization’ which is underlined text. You should be able to see the option ‘Authorize requests using OAuth 2.0’ and press the authorize toggle button. Click ‘AUTHORIZE’ and then ‘Allow’ 

In the text field ‘userKey’, insert the full email address of the user you would like to view the creation date for, and then click on ‘AUTHORIZE AND EXECUTE’

try.png

Scroll down to the Response section and you should be able to see a string of code that shows the creation date of the account user. This looks like ("creationTime": "2015-02-23T23:27:32.000Z").





netkiller.png
Netkiller, Your Professional Cloud Partner
ⓒ 2016 Netkiller, Inc. All rights reserved.

Why Barcode Scanner with Google Sheets is better than Excel

Why Barcode Scanner with Google Sheets is better than Excel



Advantages of Scanning to Google Sheets



Microsoft Excel is a common tool used in inventory management. Today you can utilize barcode applications and upload to an excel spreadsheet. But your excel file runs the risk of being lost or damaged. This is why barcode scanner for Google Sheets is essential. In fact, it is more portable and handy. Netkiller Barcode Scanner allows you to do the same exact application. It can be used as a database for inventory management. With a simple scan, an item’s information can be uploaded to Google Sheets.
Here are a few reasons why use Google Sheet would make sense as your inventory management tool.
You don’t need any new software.
You don’t need to download a new software as you can open your files in Google Sheets format in any device. Google Sheets and Google Drive allow you to be mobile wherein using just an internet and browser you can make changes and view your documents.
This is a convenient and easy way of inventory management. Furthermore, even if you don’t have an internet connection you can view your documents through Google Docs’ offline features. Google Sheets are also evolving to have more capabilities and features.


netkiller barcode scanner.png


Create Graphs with Google Sheets
With its tools, you can create graphs that will allow you to view your information in different formats. Graphs provide an accurate picture of your inventory and enables you to make reports. This is a great feature of Google Sheets based inventory management.




[New Feature in Google Sheets: Explore in Google Sheets]
Improve your inventory management workflow
Furthermore, you can use Google Sheets and Google Form as these applications are complimentary. This supports inventory management for Google Drive since a form can be filled up and integrated with the barcode scanner. The same data will be uploaded to Google Sheets making it easy to create a barcode field. This makes it easier to track the information wherein you have a unique barcode to identify items in your inventory.
Combine sheets with Google Sheet’s “IMPORTRANGE” function
It’s also effortless to manage different sheets. This is because Google Sheet has an “IMPORTRANGE” function. This enables you to conduct a thorough analytics if you have data sets across different sheets. This can be merged into one allowing you sift through the data with ease. The original data is preserved while you create a new spreadsheet that shows all of the information you need. To learn more about IMPORTRANGE function, click here.
Use Google Add-on with your barcode data
The barcode scanner for Google Sheets is a complete inventory management program wherein you will almost never lose your data. Your information is secure and readily accessible making it effortless to complete your inventory workflow tasks. You can also use Google Sheets Add-on for printing barcode labels wherein it seamlessly works with your inventory management.

It works with smartphones.


The barcode app with Google Sheet is a powerful combination in terms of inventory management. It works with any iOS and Android based smartphone and you don’t need to reinvest on heavy gadgets if you’re doing inventory management. Significantly, this is a less expensive way of managing data and having a barcode that keeps track of all your items.


A Google Sheets based barcode scanning application give you the flexibility unlike doing inventory work in Microsoft Excel. With the Netkiller Barcode Scanner, you have quick access to Google Sheets wherein you can import and export information. This allows you to have a collaborative workflow with all the information stored and secured.


Netkiller is the leading Google for Work Partner. The company provides Google Apps solutions focusing on increasing productivity. It is completely integrated, giving you access to the Google Cloud Platform, providing you with business solutions. 


* To use Netkiller Barcode Scanner your phone needs a barcode scanning application. Depending on the type of device you use, restrictions may apply.


netkiller.png
Netkiller, Your Professional Cloud Partner
Netkiller provides SaaS applications on Google Cloud Platform and advisory services for world leading businesses.
Copyright ⓒ 2015 Netkiller, Inc. All rights reserved.