See: https://workspace.google.com/marketplace/app/appsheet_for_google_docs/1022526378366 for the public version of this add-on.

This add-on allows you to interact with AppSheet apps directly from Google Docs™. It automatically converts AppSheet URLs to smart chips that can expand to display useful app data or can even be used to trigger AppSheet-configured actions without ever leaving the Doc™.