Hello,
I’ve followed the tutorial using Napkin to connect content in a Google Sheet to a campaign template.
Everything works okay, except that we routinely get slow response times from the feed and Klaviyo is warning that our refresh will switch to nightly.
Using my browser’s network inspector (and some help from ChatGPT, so I might have been misinformed) it looks like most of the delay occurs on reading from the source google sheet.
Are there any tips for improving that, anything I could be doing on the Google side of things?
The data isn’t big at all – 19 rows, 15 columns, just some basic text in the cells between 10 to perhaps 50 characters in each at the most.
here’s the function itself, largely taken from the guide article with some modifications (again that ChatGPT helped me with).