Sheet Operations Test
Google Sheets is a cloud-based spreadsheet application that enables users to create,edit, and collaborate on spreadsheets in real time from any device with internet access. It supports formulas, charts, pivot tables, and automation using Google Apps Script. Google sheets allows multiple users to simultaneously work on the same spreadsheet while the changes are saved automatically to Google Drive. With all these features, Google Sheets is extensively preferred for data analysis, budgeting, project management, and collaboration. Whereas, if the spreadsheet creation, upload, download or deletion processes fails or takes too long, it leads to workflow disruptions. This can eventually cause delays in data access and collaboration. Failed updates or uploads can result in loss of data. Also, slow deletions might leave outdated or sensitive files accessible. Failed process can also give rise to Storage constraints and system slowdowns. To prevent all these from happening, it is essential to monitor the processes and detect any issues in a timely manner.
This test keeps track of Google Sheets creation, updation, upload, download, and deletion processes, alerting administrators to any failures or slowdowns. This helps them make informed decisions well before these issues impact performance.
Target of the test : Google Workspace
Agent deploying the test : An external agent
Outputs of the test : One set of results for the Google Workspace monitored.
| Parameters | Description |
|---|---|
|
Test Period |
How often should the test be executed. |
|
Host |
The host for which the test is to be configured. |
|
Proxy Host, Proxy Port |
In some environments, all communication with the Google Workspace be routed through a proxy server. In such environments, you should make sure that the eG agent connects to the cloud via the proxy server and collects metrics. To enable metrics collection via a proxy, specify the IP address of the proxy server and the port at which the server listens against the Proxy Host and Proxy Port parameters. By default, these parameters are set to none, indicating that the eG agent is not configured to communicate via a proxy, by default. |
|
Proxy Username, Proxy Password and Confirm Password |
If the proxy server requires authentication, then, specify a valid proxy user name and password in the Proxy Username and Proxy Password parameters, respectively. Then, confirm the password by retyping it in the Confirm Password text box. |
|
Share To User |
Specify the email ID of a Google Workspace user who have access to the test operations created during monitoring. This can be the email ID of the simulation user or admin. By default, this parameter is set to none. Providing the email ID helps the specified user view and verify synthetic monitoring activities. |
|
Enable Debug |
If this flag is set to Yes, the eG agent will run in debug mode, enabling error logging. By default, this flag is set to No. |
|
DD Frequency |
Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time this test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD frequency. |
|
Measurement |
Description |
Measurement Unit |
Interpretation |
||||||
|---|---|---|---|---|---|---|---|---|---|
|
Sheet creation status |
Indicates whether/not the spreadsheet creation was succesful. |
|
If this measure reports the value Success, it means that the sheet was successfully created. On the other hand, if this measure reports the value Failed, it implies that the sheet creation failed. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the spreadsheet creation status. In the graph of this measure however, the same is indicated using the numeric equivalents only. The failure in creating spreadsheet might be due to netwrok issues, storage constraints, or system errors. |
||||||
|
Sheet creation time |
Indicates the time taken to create spreadsheets in Google Sheets. |
Seconds |
A high value for this measure indicates that spread sheet creation is taking too long, this can be due to slow internet connection, high server load, browser issues, etc. |
||||||
|
Sheet updation status |
Indicates whether/not the spreadsheet updation was succesful. |
|
If this measure reports the value Success, it means that the sheet was successfully updated. On the other hand, if this measure reports the value Failed, it implies that the sheet updation failed. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the spreadsheet updation status. In the graph of this measure however, the same is indicated using the numeric equivalents only. This measure indicates whether updates like data entry, formula execution, formatting changes, or script executions are successful. |
||||||
|
Sheet updation time |
Indicates the time taken to update spreadsheets in Google Sheets. |
Seconds |
A low value is desired for this measure. |
||||||
|
Sheet download status |
Indicates whether/not the spreadsheet was succesfully downloaded to a local device. |
|
If this measure reports the value Success, it means that the sheet was successfully downloaded. On the other hand, if this measure reports the value Failed, it implies that the sheet download failed. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the sheet download status. In the graph of this measure however, the same is indicated using the numeric equivalents only. |
||||||
|
Sheet download time |
Indicates the time taken to download spreadsheets to a local device. |
Seconds |
A low value is desired for this measure. If the sheet takes too long to download, then it could be due to large file size, slow internet, browser issues, etc. |
||||||
|
Sheet upload status |
Indicates whether/not the spreadsheet was succesfully uploaded to Google Sheets. |
|
If this measure reports the value Success, it means that the sheet was successfully uploaded. On the other hand, if this measure reports the value Failed, it implies that the sheet upload failed. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the sheet upload status. In the graph of this measure however, the same is indicated using the numeric equivalents only. |
||||||
|
Sheet upload time |
Indicates the time taken to upload a spreadsheet to Google Sheets. |
Seconds |
Sheet upload time would be affected by factors like file size, internet speed, file format, server performance, etc. |
||||||
|
Sheet deletion status |
Indicates whether/not the spreadsheet deletion was succesful. |
|
If this measure reports the value Success, it means that the sheet was successfully deleted. On the other hand, if this measure reports the value Failed, it implies that the sheet deletion failed. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the sheet deletion status. In the graph of this measure however, the same is indicated using the numeric equivalents only. Sheet deletion fails due to netwrok issues, system errors, file size and permissions. |
||||||
|
Sheet deletion time |
Indicates the time taken to delete a spreadsheet from Google Sheets. |
Seconds |
A high value for this measure can be due to large file size, netwrok problems, sync issues, server delays, system lag, etc. |