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 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.

Read more