if you are using script then follow these tutorial [Guide] RecyclerList - Google Spreadsheet - Custom Search - How to Add/Delete/Update records
You can skip the Recyclerlist layout use only how he fetched data, then use it as you want, i think it will help you
Am not familiar with extension you are using
Also did you set access Anyone with link? in you’re current gsheets