Google Sheets

Google Sheets is a web-based spreadsheet program that is part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. Google Sheets allows users to create and format spreadsheets and simultaneously work with other people. It's a popular alternative to Microsoft Excel for many users due to its cloud-based structure and collaboration features.

Key features of Google Sheets:

• Collaboration: Multiple people can work on the same spreadsheet at the same time. Users can see cursor movements and edits as they happen.
• Cloud-based: Files are saved to Google Drive, which means they are accessible from any device with internet access.
• Compatibility: Google Sheets supports many of the same functions as Excel and can import/export files to Excel format.
• Version History: You can view the edit history and revert to previous versions of the document if necessary.
• Extensions and Add-ons: There is a wide range of add-ons available that can extend the functionality of Google Sheets.
• Integrated with Google Forms: Data from Google Forms can be directly piped into Sheets for analysis.
• Functionality: It supports formulas, charts, tables, pivot tables, and conditional formatting, among other spreadsheet functions.
• Offline Mode: Users can enable offline mode to view and edit spreadsheets without an internet connection.
• Scripting and Macros: Google Sheets supports scripting through Apps Script (a JavaScript-based language) to automate tasks within a spreadsheet.
• Real-time Calculations: Changes and calculations within the sheet occur in real-time, providing instant feedback.
• API Access: Sheets has an API that allows developers to read and write to Sheets or integrate it with other services.
• Data Analysis Tools: Built-in features like pivot tables, Explore panel, and various chart options facilitate data analysis.
• Mobile App: Google Sheets has a mobile app for iOS and Android, allowing users to access and edit spreadsheets on the go.
• Security: Sheets include various privacy and security settings, allowing users to control who can view, comment on, or edit documents.
• Linking Between Sheets: You can link data between different sheets and even different spreadsheets.

Google Sheets is favoured by many for its collaborative features and ease of access. The ability to access and edit documents from any device makes it highly convenient for teams and individuals who are on the go or work in multiple locations. Its integration with other Google services, such as Google Drive and Google Data Studio, adds to its versatility as a tool for personal, educational, and professional use.

Triggers:

• New spreadsheet: Triggers when you create a new spreadsheet.
• New worksheets: Triggers when you create a new worksheet in a spreadsheet.
• New spreadsheet rows: Triggers when a new row is added to the bottom of a spreadsheet.

Actions:

• Create spreadsheet: Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
• Create spreadsheet row: Creates a new row in a specific spreadsheet.
• Create worksheet: Create a blank worksheet with a title. Optionally, provide headers.

Connect with Google Sheets:

1. Log in to your Google account.

2. Go to API Library in Google Cloud console.

3. Click the Select a project drop-down menu at the top of the page, and click the New Project button. Enter a name for your project and click the Create button.

   TIP

   In case you've already connected another Google service using the same API skip the following steps and proceed to step 8.

4. Go to API Library in Google Cloud console.

5. Search for People API in the search bar and click on it.

6. Click on Google People API in the list.

7. Click on the Enable button to enable the API.

8. Repeat steps 4, 5, 6, and 7 for the Google Drive API and the Google Sheets API.

9. Go to OAuth consent screen in the Google Cloud Console.

10. Select External to start your app in testing mode at first. Click the Create button.

11. Fill in App Name, User Support Email, and Developer Contact Information. Click the Save and Continue button.

12. Skip adding or removing scopes and click on the Save and Continue button.

13. Click the Add Users button and add a test e-mail address since only test users can access the app while the publishing status is set to "Testing".

14. Enter an e-mail address and click the Add button in the Add User window.

    WARNING

    Make sure to use the same e-mail address you're logged into Google with as the test user e-mail address.

    

15. Click the Save and Continue button to complete the configuration of the consent screen.

16. Go to Credentials.

17. Click the Create Credentials button and select the OAuth client ID option.

18. Select the application type as Web application.

19. Fill in the Name field.

20. Go to Mation and navigate to My Apps and Add a new connection choosing Google Forms from the list.

21. Copy the OAuth Redirect URL.

22. Go back to Google Cloud Console and click the Add URI button in the Authorized redirect URIs section.

23. Paste the OAuth Redirect URL into the Authorized redirect URIs field and click the Create button.

24. Copy the Your Client ID value from the following popup and paste it into the Client ID field on Mation.

25. Copy the Your Client Secret value from the same popup and paste it into the Client Secret field on Mation.

26. Click the Submit button on Mation.

27. A pop-up window appears. Select your Google account in the pop-up window.

28. Click the Continue button.

29. Check the Select all checkbox.

30. Scroll down to the bottom of the pop-up window and click the Continue button.

31. Your Google Sheets connection is now established.

32. Start using your new Google Sheets connection with Mation.