You can add a embeded Typeform that will pop-up when a user will click a link or a button
To add a typeform please add a typeform link like
https://andreyazimov.typeform.com/to/fM7ndm
in your Google Sheet navbar tab
Demo (click post a job in the top right corner)
Import Typeform to Google Sheet
Also you can automatically import result of your Typeform to Google Sheet
Open it from your Workspace, then click on Connect. Now you can see our integrations, so click on Connect in the Send responses to Google Sheets box.