How to use "Add Items to Sheet"
The Add Items action allows you to add multiple entries to your Google Sheets in one go. This is ideal when you need to import bulk data, such as a list of products or users, or when you're pulling data from a dynamic source that contains multiple items.
When to Use "Add Items"
When you have a list of items that need to be added in bulk (e.g., a list of orders, customers, or products).
When your flow is generating a series of related entries that should be imported together, such as campaign data or performance metrics.
How to Use "Add Items"
Select the Sheet: Choose the specific Google Sheet where the items will be added.
Map Your Data: Ensure that your data source (whether it’s an API, CSV, or a different flow step) contains the information for multiple items that need to be added.
Map Fields: Map the fields accordingly, ensuring each piece of data is correctly matched to the columns in your sheet.
Run the Action: Execute the action to add all the items to the specified sheet at once.