Automating Auto-Refresh for Error-Free Spreadsheet Columns

Hey guys! Is there a way to keep auto-refreshing a column until all errors are solved? And is there a way to automatically do this for a whole sheet? I keep getting errors when i use chatgpt for a column. And every time i refresh, it takes a while to load and I'd always need to refresh it again. Is there a way to automate this part of the process?

5 comments

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Tanvi R.
·
·
Hi Francis, thanks for reaching out! Do you mind sending the link to the table so we can take a look? I'm curious why you keep getting errors with your chatgpt column and would love to investigate here! https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1729863000&signature=a31c16eaeba41bac2f8167a702359e68ca87b9462433d2db22eb55bc83b5eae9&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCL0AJQW2BKsam%2FhVPu99g%3D%3D%0A
Tanvi R.
·
·
If you're consistency needing to re-run to resolve your errored cells with your gpt column, my guess is you're experiencing rate limit issues with an OpenAI key. There currently isn't a way to set a column to auto-refresh/re-run. We have auto-update, but this will automatically run the columns in your entire table once, not re-run specific columns. A workaround I'd recommend here is actually switching to the Errored Rows view for your table. If you switch to the errored rows view instead of default view, it will automatically apply filters to your enrichment columns to see the Errored cells. From here it's much easier to select run for the entire column and it will only run the cells that are visible (in this case errored cells)! Give this a try and let us know if it becomes easier for you! https://downloads.intercomcdn.com/i/o/w28k1kwz/1228838356/7470a78291ed3786b5d4d6a6cf07/CleanShot+2024-10-25+at+09_05_08%402x.png?expires=1729863000&signature=82df4b56ff9f7e880e594bcca2e65803ad1b91d764cb756336244383eaa3da86&req=dSIlHsF9lYJaX%2FMW1HO4zf8GRdgx9PmGoQ0H6QoCwCT8yW8ZJhT0B3SmXWZO%0AJ7r%2B%0A
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Francis! This thread was recently closed by our Support team. If you have a moment, please share your feedback: