This topic was automatically generated from Slack. You can find the original thread here.
ask-pi how to send info from notion to google sheets
: how to send info from notion to google sheets?
To send information from Notion to Google Sheets, you can create a Pipedream workflow with the following steps: 1. Use the Notion trigger or action (e.g., “Search” or “Retrieve Page”) to get the data from Notion. You can find these actions by searching for the Notion app in the Pipedream step menu. 2. Add a Google Sheets action to your workflow. Search for the Google Sheets app in the step menu, and select the “Add Single Row” action. 3. Connect your Google Sheets account to Pipedream and select the spreadsheet and sheet you want to send the data to. 4. Map the data from the Notion step to the appropriate columns in the Google Sheets step. Here’s an example of how to use the Notion “Search” action and Google Sheets “Add Single Row” action: 1. Add the Notion “Search” action to your workflow and connect your Notion account. 2. Configure the optional props for the Notion “Search” action, such as Query, Sort Direction, Page Size, Start Cursor, and Filter, as needed. 3. Add the Google Sheets “Add Single Row” action to your workflow and connect your Google Sheets account. 4. Select the spreadsheet and sheet you want to send the data to. 5. Map the data from the Notion “Search” step to the appropriate columns in the Google Sheets step. Once you’ve set up the workflow, it will automatically send the data from Notion to Google Sheets when triggered.