Tutorials
How to use Memory

1. Introduction
In this tutorial, we will explore the Memory
section of Yala in detail. Yala is a powerful extension that integrates AI into Google Sheets to automate and streamline workflows. The Memory
section allows you to provide additional context during processing, making the system’s responses and actions more relevant. Understanding how to use this functionality is crucial to making the most of Yala’s capabilities.
Remember that in your sheet (for example, the Nutritionist
tab), you might have columns such as Task
, Category
, Product
, Composition
, and Status
—alongside Memory Type
, Memory Prompt
, and Memory Output
.
2. How Memory Works
The Memory
section is designed to supply contextual information that Yala can use while executing prompts. This is especially helpful when you need the system to consider specific or historical data (e.g., from columns like Category
, Product
, Composition
) while generating responses or performing actions.
Operational Flow
Selecting the Memory Type
You pick the memory scope you want to use, such as Spreadsheet
, Sheet
, Row
, or Custom
.
Providing the Memory Prompt
You enter any instructions or additional details that will be combined with the chosen memory scope (for instance, “Obtain the Category
, Product
, and its Composition
information.”).
Processing
Yala takes the Memory Type
and Memory Prompt
to generate the Memory Output
, which can then be used in later stages of the workflow.
Interactions with Other Components
Agent
The Memory Output
can be utilized by the AI when it processes the User Prompt
, adding extra context to produce more accurate answers (such as how to classify or generate nutritional information for the Product
).
Parsing and Action
Details from Memory Output
can influence how data is analyzed or which tasks (Action Prompt
) are performed (for example, moving to another row or inserting data into another tab).
3. Required Parameters and Inputs
Input Data
Memory Type
Determines the memory scope to be used (e.g., Row
to consider the specific row that has columns like Task
, Category
, Product
, Composition
).
Memory Prompt
Additional instructions or information that complement the chosen memory type (e.g., “Combine the data from this row to form a quick summary.”).
Prerequisites
Relevant Data
Ensure that any data you want to use is correctly filled in the appropriate columns or tabs (for instance, Category
, Product
, Composition
in the Nutritionist
tab).
Proper Configuration
Select a Memory Type
that fits the context of your workflow (if you only need data from one row, choose Row
; if multiple tabs, choose Spreadsheet
or Sheet
).
4. Detailed Look at the Memory Columns
Memory Type
Description
Defines the scope of memory that Yala should use in your workflow.
Options
Spreadsheet: Considers data from the entire spreadsheet.
Sheet: Considers data only from the current tab.
Row: Considers data from the current row (for example, the row containing Category
, Product
, Composition
).
Custom: Lets you specify your own custom data or instructions.
How to Use
Select one of these options from the dropdown menu based on the scope you need. For instance, if you want Yala to focus solely on the current row, choose Row
.
Memory Prompt
Description
A field where you add instructions or extra details to be used together with the chosen Memory Type
.
How to Use
Write the text that should serve as memory context. For example: “Obtain the Product
details from this row and summarize them.”
Memory Output
Description
Shows the result generated from combining Memory Type
and Memory Prompt
.
How to Use
This column is filled automatically once Yala processes the memory. Check it to see how the system interpreted the instructions you provided. You can then use the generated Memory Output
in Agent
, Parsing
, Data
, or Action
prompts.
5. Practical Examples
Example 1: Using Memory from the Current Row
Scenario
You want Yala to create a personalized message based on data from columns Task
, Category
, Product
, and Composition
in the current row.
Steps
Set Memory Type
to Row
.
In Memory Prompt
, enter: “Use the data from the current row to create a message about the Product
.”
Set Status
to Pending
to begin processing.
Result
The Memory Output
will contain the combined information from Category
, Product
, Composition
, etc., ready to be used by an Agent
or in a Parsing
operation.
Example 2: Querying Data from Another Tab
Scenario
You need Yala to gather nutritional summaries from a tab called Nutritional Table
.
Steps
Set Memory Type
to Sheet
.
In Memory Prompt
, enter: “Provide a list of all items in the Nutritional Table
tab that are labeled as cakes.”
Make sure the Nutritional Table
tab exists and is up to date.
Set Status
to Pending
.
Result
The Memory Output
will give you a filtered view of items identified as cakes from the Nutritional Table
tab.
6. Best Practices
Choose the Right Memory Type
Pick the memory scope that best fits your context (e.g., Row
for data in columns like Product
and Composition
, or Sheet
if the entire tab is relevant).
Clarity in the Memory Prompt
Provide concise, direct instructions so Yala knows exactly what you want.
Check Your Data
Make sure that any referenced tabs or columns (Category
, Product
, Composition
) are correct and up to date.
Use Memory Wisely
Avoid requesting large amounts of data you don’t actually need, as it may affect processing performance.
7. Troubleshooting
Empty or Unexpected Memory Output
Confirm that Memory Type
is configured correctly.
Double-check your Memory Prompt
for clarity and specificity.
Processing Error
If Status
changes to Failure
, review the Memory Output
for potential error messages.
Verify that the tabs or data you’re referencing (like Nutritional Table
) exist and are spelled correctly.
Outdated Data
Update information in the relevant tabs or columns.
Reprocess the row by setting Status
to Pending
again.
8. Relationship with Status
Pending
After choosing your Memory Type
and Memory Prompt
, set Status
to Pending
so Yala can process the memory.
Processing
Indicates that Yala is executing the memory instructions you set.
Success
The Memory Output
was successfully generated and is ready for subsequent steps (like Agent
, Parsing
, or Data
).
Failure
An error occurred. Check your inputs as described in the troubleshooting section.
9. References and Additional Resources
Complementary Guides
Check the Agent
tutorial to learn how Memory Output
can be combined with a User Prompt
.
Review the Parsing
tutorial to extract specific information from the Memory Output
.
Support
If you continue to have questions or issues, contact the Yala support team for further assistance.
By understanding the Memory
section, you can significantly enrich the context of your workflows, enabling Yala to provide more accurate and relevant responses and actions. Experiment with different combinations of Memory Type
and Memory Prompt
—for example, referencing columns like Category
, Product
, Composition
—to see how they can meet your specific project needs. Take full advantage of this functionality to optimize your processes and get even better results!