What is the procedure to adjust the behavior of an agent step that needs minor fixes: i.e. the format of extrated data into Gsheet ?
Hey Ignazio! If you're using a 'skill' to append a GSheet, all Agent Step change will happen via prompt! A couple notes here:
I would advise to use a separate action to append a google sheet, as you can be more specific and precise
If you do use the Agent Step, you will have to provide as much info as possible!
Thank you!
I need data to be extrated and copied only in the first few columns cell when a row is appended. I noticed that whenever there is even just a formula, the row would be skipped. Is there a way to avoid this? I need some calculations to happen with the copied data
If you use the Append Row action (not within the Agent step), the columns will be listed in the action. You can then change each column that you don’t want to update to “Prompt AI” and say something like “Do not fill this in” In regard to the skipping, do you have a specific example? I’m not quite sure I understand 🙏
If there is even just one cell with values in the row (i.e. a formula that returns zero because is referenced to blank cells in the same row) the row will be skipped. If there is a table format (which i use ìbecause of the many useful features, the append row will use the first non table formatted row. I hope this explains
