What happens (detailed):
- Every time I click Run in Tab (or use the public link) the agent finishes with the banner “Completed Successfully with No Output.”
- The debugger timeline shows the blocks up through Generate Text, but the downstream Run-Function block
write_to_google_sheet
never fires (no console logs, no status/body).
- Because that block doesn’t execute, no POST request reaches my Google Apps Script Web-App, so no rows are written to the Google Sheet.
// @standalone
is in place, Test Data is set, Transition Type = Dynamic, yet the single-function Test runner also refuses to start.
- Curling the Web-App URL directly returns “Success” and appends rows, so the endpoint itself is healthy.
Intended behavior:
write_to_google_sheet
should receive steps.generate_text.result
, POST the JSON array to my Web-App URL, and append new rows to the BozLeads tab of the sheet.
Agent links:
Attachments:
- Screenshot #1 – success banner with “No Output.”
- Screenshot #2 – debugger timeline (note missing
write_to_google_sheet
step).
- Run-log JSON – exported from the latest run.
- Apps-Script execution log – shows no requests arrive during the MindStudio run, but succeeds when hit via curl.
Environment:
- Workspace plan: Pro
- Browser: Chrome v115 on macOS 14.5
- Agent duplicated into a fresh project / incognito window — same result.
Let me know if you need any additional logs or a Loom; happy to provide. Thank you!
It looks like you’re using a Custom Function? We don’t support the actual code within a Custom Function - it’s on the developer to make sure it works.
Have you tried our native Google Sheet block instead of a custom function?
I’m new to Mindstudio. I didn’t see a Google block. Is there one?
Hi @slaflora,
When adding a block, scroll down to the Google section to add an Update Google Sheet or similar block:
1 Like
Thanks Alex. I added the google sheet bloc, but still can’t figure it out.
-
What happens
-
I’m trying to append rows to my Google Sheet from an agent called Boz.
-
Current workflow: Start → Scrape URL → Generate Text (returns a valid JSON array of 8 columns) → json_to_csv
function → Update Google Sheet block → End.
-
When I run the agent in the debugger the Google-Sheet action fails with
Error: CSV parse error: Unable to auto-detect delimiting character; defaulted to ','
New Content: "" (empty string)
and nothing is written to the sheet.
-
Intended behaviour
The JSON array should be converted to CSV (header row + data rows) and appended at the bottom of the sheet BozLeads in spreadsheet ID 1ekKKoREl3fcSRkr88hnlO0OyqVqYcKpxu7PxyScTHJw
.
-
Agent link
Draft agent: https://app.mindstudio.ai/agents/boz-534d312c (run ID examples are in the debugger).
-
Assets
-
Screenshot of the failure dialog (attached: RunFailed_CSVParseError.png
).
-
Screenshot of the canvas showing the blocks and the json_to_csv
code (attached: Boz_Workflow.png
).
-
Code inside json_to_csv
:
async function run({ steps }) {
const data = JSON.parse(JSON.stringify(steps.generate_text.result)); // guaranteed array
const header = ['Type','First Name','Last Name','Company','Role',
'Fundraising Platform','Email','LinkedIn','Status'];
const rows = data.map(o => header.map(h => (o[h] ?? '').replace(/,/g, ' ')).join(','));
return header.join(',') + '\n' + rows.join('\n');
}
I’ve also tried dropping the CSV step and sending JSON directly to a Web-App URL (Apps-Script) – that worked, so the sheet itself and the JSON are fine. The issue seems isolated to the Update Google Sheet block when the content field is populated with {{steps.json_to_csv.result}}
.
Could you let me know what I’m missing or if this is a known bug?
Thank you!
Hi @slaflora,
Thanks for sharing all these details!
Since you’re already using a Generate Text block, you can update the prompt to output in a Google Sheet-friendly format instead of using a Custom Function. The Spreadsheet Content field shows the expected format:
Just in case, here’s a sample agent you can remix into your workspace to explore the structure:
https://app.mindstudio.ai/agents/update-google-sheet-d031c9c1/remix
Make sure you’ve selected the Google Sheet before running the agent.
That message shows up because there aren’t any blocks in your workflow set to display content. If you’d like to preview the data that was added to the Google Sheet, you can add a Display Content block and either:
-
Reference the variable with the data and set the Display Type to CSV:
-
Embed a link to the Google Sheet:
Access the Google Sheet by clicking [here](<https://docs.google.com/spreadsheets/ABC>)
Let me know how it goes!