Paste an Apps Script Web App URL (Deploy → New deployment → Web app → Access: Anyone).
Backend script is Code.gs — paste it into that sheet's Apps Script editor.
Columns are auto-detected per sheet, so switching sheets with a different layout just works.