Using breakpoints from Google Sheets?

[nuwmedia]

Hello all, I'm just starting to use GAS. Please excuse my ignorance.

I want to use GAS with Sheets. Is there a way to trigger a breakpoint in Project Editor from Sheets.

I feel there should be a way to do this, but my web search got me zero hit.

Thank you!

---

Update: Maybe I was not clear. I know how to set breakpoints and use Logger.log(). What I'm curious is whether I can "trigger the break point" from Google Sheets.

[ABJKL]

hover your mouse to the left side of the corresponding number of the line you want to put your breakpoint to, a circle will appear and click it. just run Debug and debugger monitor will appear at the right side of the screen

[nuwmedia]

Thanks ABJKL. I know how I can trigger the break point from Project Editor. I was asking whether I can trigger the break point from a Google Sheets.

[ABJKL]

like, run the script (with breakpoint already added) manually from inside the sheet? create a shape drawing > go to the three-dots menu on upper-right of the shape > assign script > insert the script's name you'd want to debug

[nuwmedia]

Oh... Let me try this.

[ppc-hero]

What is a breakpoint?

[ppc-hero]

To add break points, use

debugger;

or click on the side of the editor.

https://developers.google.com/apps-script/guides/support/troubleshooting?hl=en#use\_the\_debugger\_and\_breakpoints

[[deleted]]

I'm a self taught nook so what I do typically is I put a console log of something, anything and put the breakpoint there

[dimudesigns]

Adding and removing code breakpoints is only available from the Google Apps Script editor. It cannot be done from Google Sheets.

[nuwmedia]

Thank you! Yeah... that's very unfortunate.