Google Sheet Integration in Mewayz
Google Sheet Management is a powerful Add-On solution that allows users to seamlessly connect with their Google account and manage Google Sheets directly from the system.
Introduction
Google Sheet Management is a powerful Add-On solution that allows users to seamlessly connect with their Google account and manage Google Sheets directly from the system. The software enables users to view, create, edit, and organise their Google Sheets without switching between different platforms. Users can perform essential operations like creating new sheets in specific folders, copying shareable links, editing sheet content and titles, and managing their Google Sheets efficiently from a centralised interface.
How to Install the Add-On?
To Set Up the Google Sheet Add-On, you can follow this link: Setup Add-On.
How to use the Google Sheet Add-On?
System Settings – Google Sheets Configuration
- After purchasing and installing the Google Sheets
- To set up Google Sheets integration, navigate to Google
- To learn how to generate the credentials, follow this
- You need to enable the following APIs in your Google
- Complete the authentication process by signing in with
Add-On, navigate to the sidebar and search for this Add-On to begin using it.
Sheets Settings. Here, you will need to add your Google Client ID and Client Secret generated from the Google Cloud Console.
link: https://console.cloud.google.com/.
Console: Google Drive API and Google Sheets API. While creating credentials, make sure to set the Authorised Redirect URI properly, as it is required for authentication.
your Google account and granting the required permissions.
- After a successful connection with your Google account,
you will be able to view and manage your Google Sheets directly from the system.
Google Sheets Management
- The Google Sheets List View displays all your sheets in
- The Grid View displays the same information in an
- With the help of the action column, you can easily copy
a table format with columns including Sheets, Created Date, Updated On, and Action.
organized card layout for better visual browsing.
the link, view, edit, or delete the google sheets whenever you want.
Copy Link
- When you click the “Copy Link” button next to a Google
- You can then paste this link into your browser, and it
- You can also share this copied link with other team
Sheet, the direct link to that google sheets is automatically copied to your clipboard.
will open the spreadsheet directly in your Google Sheets account, where you can perform all standard spreadsheet functions, including data entry, formula creation, formatting, and collaboration features.
members or stakeholders to provide them direct access to the specific Google Sheet.
View
- If you click on the “View” button from the Action
- On this page, you can see the sheet title and all its
- The page displays the actual Google Sheet data, allowing
- This view mode is perfect for quickly checking sheet
column, you will be taken to the View Sheet page where you can open and preview the sheet.
data in a read-only format.
you to review cells, data entries, and existing information without making any modifications.
contents without the risk of accidental changes.
Edit
- If you click on the “Edit” button from the Action
- On this page, you can update the sheet title by editing
- Below that, you can modify the content of the sheet
- After making your changes, the updates are automatically
column, you will be taken to the Edit Sheet page where you can modify the sheet’s title and data.
the title field at the top of the page.
directly. The page displays the actual Google Sheet data in an editable format, allowing you to make changes to cells, add new data, or modify existing information.
saved to your Google Drive, ensuring seamless synchronisation between your project and Google Sheets.
Create New Google Sheet
- To create a new Google Sheet, click the “Create” button,
- Fill in the following form details:
and you will be taken to a form page with the following options:
- Folder Selection: Select the folder in your Google
- Sheet Title: Enter the name for your new sheet in
- Upon submission, the sheet is created in the selected
Drive where the new sheet should be created from the dropdown menu.
the Sheet Title field.
folder in your Google Drive and becomes immediately visible in the sheets list.
Note: All sheets created in your project will automatically appear in your Google Drive, and any sheets created directly in Google Drive will also be visible in your project due to the bidirectional synchronisation feature.