Q: If I have a Sheet with an API(...)
call in column F that depends on cells in columns C, D, and E; will F be automatically fired if cells in columns C, D or E were injected by some external app like Pabbly Connect? Note that the Sheet might not even be opened on any computer at all.
Wei_Sheng
May 15, 2024A: Hi there, thanks for your question.
I just did some experiments and found that what you described is possible. I used the same setup and used an external API to change the value of the referencing column. When my spreadsheet is not opened, the =API() function still sends out a new request, which I can see from my API server. So yes, as long as the AI function depends on the columns being updated by external apps, the API function will refresh.
One thing you have to be aware of is that external apps like Pabbly may "append" a new row to the end of the sheet, meaning that if there is already something in column F(in your case), the new row will be appended to the next row of your API function. But it depends, you can give it a try and see if it works.
Best wishes,
Wei