This applet works with any spreadsheet that you can access no matter who created it. When you turn on the applet, you can either paste in a shareable link to the spreadsheet or enter the spreadsheet's path and file name. You can get the shareable link from Google Sheets. The notification you get has the following format: A new worksheet named "{new_worksheet_name}" was added to {spreadsheet_name}.
If
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Then
Send a notification from the IFTTT app
This action will send a notification to your devices from the IFTTT app.
Discover more time saving integrations for Notifications and Google Sheets