Search related keywords with SerpApi and send notifications based on new Microsoft SharePoint files
Search related keywords with SerpApi and send notifications based on new Microsoft SharePoint files
Launch this workflow to connect
Microsoft SharePoint &
SerpApi
!
■Overview
Every time a new file is added to Microsoft SharePoint, reviewing its contents and manually searching for related information can be time-consuming. This manual work can become a bottleneck, especially when fast information gathering is essential. With this workflow, adding a file to Microsoft SharePoint triggers OCR to extract text from the file, automatically searches for related information with SerpApi, and sends notifications—streamlining your research process from start to finish.
■Recommended for
- Those who manage information in Microsoft SharePoint and find manual follow-up research time-consuming
- Those who want to automate web searches with SerpApi based on the contents of uploaded files
- Those who want to streamline routine research tasks and focus more on core work, such as analysis
■Benefits of using this template
- Automatically run searches and send notifications when a file is added to Microsoft SharePoint, reducing the time spent gathering information manually.
- Prevent human errors such as mistyped keywords and missed searches, maintain research accuracy, and reduce reliance on individual expertise.
■Workflow
- First, connect Microsoft SharePoint and SerpApi to Yoom.
- Next, select Microsoft SharePoint as the trigger and set it to “When a file is created or updated in a specified folder on a site.”
- For the operation, set Microsoft SharePoint’s “Download a file” action to download the file detected by the trigger.
- Next, set the OCR feature’s “Extract text with OCR” action to extract text from the downloaded file.
- Then, configure the branching feature and set the conditions for subsequent processing based on the information obtained in the previous step.
- For the operation, set SerpApi’s “Get Google search results” action to run a search based on the extracted text.
- Finally, set the email feature’s “Send an email” action to notify relevant stakeholders of the search results obtained from SerpApi.
※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization options
■Customization options
- In the Microsoft SharePoint trigger settings, set the site ID and folder ID you want to monitor.
- With the branching feature, you can set conditions for running subsequent operations, such as whether the text extracted with OCR contains specific words.
- With the OCR feature, you can customize settings such as which part of the target file to extract text from.
- In the SerpApi search settings, you can use fixed values or information obtained in previous steps as variables, such as setting the text extracted with OCR as the search keyword.
- In the email settings, you can specify the recipients, subject, and body. You can also include information from previous steps as variables in the body, such as the search results obtained from SerpApi.
■Notes
- Connect both Microsoft SharePoint and SerpApi to Yoom.
- Microsoft365 (formerly Office365) offers plans for home use and general business use (Microsoft365 Business). Authentication may fail if you are not subscribed to a general business plan.
- Due to the app’s specifications, the file creation date and last modified date may not be the same, which may result in incorrect branching.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- Paid plans such as the Mini, Team, and Success plans offer a two-week free trial. During the free trial, you can use apps that are otherwise subject to restrictions.
- Branching is a feature (operation) available on the Personal plan and above. On the Free plan, operations in configured flow bots that use branching will result in errors.
- Paid plans such as the Personal plan offer a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.
- The maximum file size available for download is 300 MB. Depending on the app’s specifications, the limit may be less than 300 MB.
- When using files in triggers or operations, see File size limits.
- Microsoft SharePoint is available on the Mini plan and above. On the Free and Personal plans, operations and Data Connect configured in flow bots that use Microsoft SharePoint will result in errors.
- When searching, combining multiple keywords can help you retrieve relatively accurate information.
Check Out Similar Templates!
Automatically create a folder in Microsoft SharePoint every month and notify in Microsoft Teams.
Every month, this business workflow automatically creates folders in Microsoft SharePoint and notifies Microsoft Teams. It reduces the burden of folder management and facilitates smooth information sharing within the team.
Download a CSV from a specific website at the scheduled time and upload it to Microsoft SharePoint.
This is a flow that downloads a CSV from a specific website according to a specified schedule and uploads it to Microsoft SharePoint. This allows the person in charge to focus on their primary tasks and improves data accuracy and reliability by preventing human errors.
See more
About the Apps
Templates using
Microsoft SharePoint
Automatically create a folder in Microsoft SharePoint every month and notify in Microsoft Teams.
Every month, this business workflow automatically creates folders in Microsoft SharePoint and notifies Microsoft Teams. It reduces the burden of folder management and facilitates smooth information sharing within the team.
This is a business workflow that automatically creates folders in Microsoft SharePoint every month. By reducing manual work and preventing errors, it improves the team's operational efficiency.
The business workflow automatically stores files attached to the form in Microsoft SharePoint. It eliminates the need for manual work, streamlining business efficiency and centralizing data management.
SerpApi
Related apps
Templates using
SerpApi
Regularly search Notion records with SerpApi, then use AI to summarize and append the results. Reduce the effort of searching and transferring information while keeping your data fresh and high-quality.
About the apps you use
Microsoft SharePoint
Yoom allows integration with SharePoint's API without code, enabling the automation of various tasks related to SharePoint. For example, you can create folders within SharePoint and automatically upload any files to those folders, or freely duplicate files within SharePoint. It can be used in various use cases, such as automatically storing email attachments in SharePoint or integrating with CRM to automatically create customer-specific folders within SharePoint.
see detailsTemplates
Automatically create a folder in Microsoft SharePoint every month and notify in Microsoft Teams.
Every month, this business workflow automatically creates folders in Microsoft SharePoint and notifies Microsoft Teams. It reduces the burden of folder management and facilitates smooth information sharing within the team.
Automatically create a folder in Microsoft SharePoint every month and notify in Microsoft Teams.
This is a business workflow that automatically creates folders in Microsoft SharePoint every month. By reducing manual work and preventing errors, it improves the team's operational efficiency.
Automatically create a folder in Microsoft SharePoint every month.
The business workflow automatically stores files attached to the form in Microsoft SharePoint. It eliminates the need for manual work, streamlining business efficiency and centralizing data management.
Automatically store form attachments in Microsoft SharePoint
SerpApi
Yoom allows seamless integration with SerpApi without any coding, enabling automatic retrieval of search results from Google, Google Maps, and more via API. For instance, you can perform searches on Google using information registered in Google Sheets or Notion and automatically store the search results, all without needing to write any code.
see detailsTemplates
Regularly search Notion records with SerpApi, then use AI to summarize and append the results. Reduce the effort of searching and transferring information while keeping your data fresh and high-quality.
Run Google searches with SerpApi regularly based on Notion record data, and add the results
No-Code API Actions
Executable API actions
Flowbot triggers
When Item Is Added or Updated in List
When a File Is Created or Updated in a Specified Folder Within the Site
When a Folder Is Created or Updated in a Specified Folder Within the Site
Flowbot operations
Upload File
Create Folder
Search Folders/files
Copy File
Set Values in Document Custom Columns
Get Item Details
Download File
Create Folder in Drive Root
Retrieve Information for a Specific List
Get Item Access Count and Unique Users (All Time)
Get Item Access Count and Unique Users (Last 7 Days)
Delete File / Folder
Move File to Another Folder
Add Item to List
Update List Item
Update List Item (Multiple Choice)
Get Folders/files in a Specific Folder
Get Initial Delta Link for a Specified List
Flowbot triggers
When Item Is Added or Updated in ListWhen a File Is Created or Updated in a Specified Folder Within the SiteWhen a Folder Is Created or Updated in a Specified Folder Within the Site
Flowbot operations
Upload FileCreate FolderSearch Folders/filesCopy FileSet Values in Document Custom ColumnsGet Item DetailsDownload FileCreate Folder in Drive RootRetrieve Information for a Specific ListGet Item Access Count and Unique Users (All Time)Get Item Access Count and Unique Users (Last 7 Days)Delete File / FolderMove File to Another FolderAdd Item to ListUpdate List ItemUpdate List Item (Multiple Choice)Get Folders/files in a Specific FolderGet Initial Delta Link for a Specified ListGet Incremental Changes for List ItemsSearch Folders/files (for Next Page)Rename FolderAdd WorksheetUpdate List Item (Hyperlink)Retrieve Specific Item Information (Specify Drive ID)
Flowbot triggers
There is no action.
Flowbot operations
Retrieve Google Search ResultsRetrieve Google Images Search ResultsRetrieve Google News Search ResultsRetrieve Google Local Search ResultsRetrieve Google Maps Search ResultsGet YouTube Search ResultsGet Bing Search ResultsGet Google Finance Search ResultsGet Baidu Search ResultsGet Yelp Search ResultsGet Google Search Keyword Suggestions (Autocomplete API)More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
