📝 Overview
This guide outlines the capabilities and limitations when integrating Yoom with Google Sheets.
By integrating Yoom with Google Sheets, you can:
Add data (e.g., form responses) to a spreadsheet without direct access.
Copy sheets (tabs) or embed functions.
Automate data entry and spreadsheet management.
🙌 What You Can Do
Feature | Details |
Register, edit, delete, or retrieve rows | Directly manage row data in Google Sheets. |
Enter or retrieve values in a specific range | Input or extract data from specific cells or ranges. |
Copy or delete sheets (tabs) | Duplicate or remove tabs within or across spreadsheets. |
Retrieve formula results | When retrieving cells with functions, the calculated result is returned. |
🙅♀️ What You Cannot Do
Limitations | Details |
Change PDF orientation | Cannot modify PDF orientation while issuing the document. |
Format cells or change fonts | Formatting and font changes are not supported. |
Handle | Only native Google Sheets files are supported. |
Unsupported Actions | Any actions not listed in the official action list. |
⚖️ Comparison of Yoom Integration Methods
🗃️ Operating a Database
Use this method when working with entire rows in the spreadsheet, especially for:
Add, retrieve, edit, or delete rows
👫 Integrating with an App
Use this method for cell-specific or spreadsheet-wide operations like:
Enter data into a specified cell
Copy or delete sheets (tabs)
📄 Issuing Documents
Use this when generating PDFs based on Google Sheets templates:
Replace texts in templates with dynamic data
Create PDFs like invoices or certificates
📍 Example:
Use a Google Sheets invoice template.
Replace the placeholder text with actual data (e.g., company names, amounts).
Export the completed sheet as a PDF invoice.
📋 List of Actions
• Actions for Integrating with an App
Action | Details |
Enter a value into a cell | Input a value into a specific cell. |
Retrieve values | Get data from the defined range. |
Delete values | Clear values from the selected range. |
Create a new spreadsheet | Start a new Google Sheet. |
Copy a sheet (tab) | Duplicate a tab within or across spreadsheets. |
Add a new sheet (tab) | Insert a new tab into the spreadsheet. |
Delete a sheet (tab) | Remove a specified tab. |
Replace a value | Find and replace a specific value. |
Update sheet name | Rename a sheet (tab). |
Delete rows | Remove rows from the selected range. |
Retrieve spreadsheet info | Get details from a specified spreadsheet. |
Retrieve sheet names | List all tabs within a spreadsheet. |
Repeat a formula | Embed a function across a defined range. |
Enter values in a range | Bulk input values into multiple cells. |
• Actions for Operating a Database
Action | Details |
Add a record | Add a new row to the spreadsheet. |
Retrieve a record | Get a single row matching the search criteria. |
Retrieve multiple records | Retrieve up to 10 rows matching the search conditions. |
Update a record | Modify a row that matches the search criteria. |
Delete a record | Remove a row that matches the search criteria. |
• Actions for Issuing Documents
Action | Details |
Issue a document | Generate a PDF using a Google Sheets template with replaced text. |
📚 Related Guides
How to Set Up Document Issues in Yoom - View Guide Here
Related Keywords
Related Keywords
Google Spreadsheet, Spreadsheet, Google, Google Sheets, Yoom Integration, Database, GSS, Database, PDF Issuance, Automation