← Google Drive + SERPhouse integrations

Perform Search with SERPhouse API on New Presentation (Instant) from Google Drive API

Pipedream makes it easy to connect APIs for SERPhouse, Google Drive and 3,000+ other apps remarkably fast.

Trigger workflow on
New Presentation (Instant) from the Google Drive API
Next, do this
Perform Search with the SERPhouse API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a Google Drive trigger and SERPhouse action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New Presentation (Instant) trigger
    1. Connect your Google Drive account
    2. Select a Drive
    3. Configure Push notification renewal schedule
    4. Configure alert
    5. Optional- Select one or more Folders
  3. Configure the Perform Search action
    1. Connect your SERPhouse account
    2. Configure Query
    3. Select a Domain
    4. Select a Language
    5. Select a Device
    6. Select a SERP Type
    7. Configure locationAlert
    8. Optional- Select a Location
    9. Optional- Configure Verbatim
    10. Optional- Configure GFilter
    11. Optional- Configure Page
    12. Optional- Configure Number of Results
    13. Optional- Select a Date Range
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new event each time a new presentation is created in a drive.
Version:0.0.4
Key:google_slides-new-presentation

Google Drive Overview

The Google Drive API on Pipedream allows you to automate various file management tasks, such as creating, reading, updating, and deleting files within your Google Drive. You can also share files, manage permissions, and monitor changes to files and folders. This opens up possibilities for creating workflows that seamlessly integrate with other apps and services, streamlining document handling, backup processes, and collaborative workflows.

Trigger Code

import newFilesInstant from "../../../google_drive/sources/new-files-instant/new-files-instant.mjs";

export default {
  ...newFilesInstant,
  key: "google_slides-new-presentation",
  type: "source",
  name: "New Presentation (Instant)",
  description: "Emit new event each time a new presentation is created in a drive.",
  version: "0.0.4",
  hooks: {
    ...newFilesInstant.hooks,
    async deploy() {
      // Emit sample records on the first run
      const slides = await this.getPresentations(5);
      for (const fileInfo of slides) {
        const createdTime = Date.parse(fileInfo.createdTime);
        this.$emit(fileInfo, {
          summary: `New File: ${fileInfo.name}`,
          id: fileInfo.id,
          ts: createdTime,
        });
      }
    },
  },
  props: {
    ...newFilesInstant.props,
    folders: {
      ...newFilesInstant.props.folders,
      description:
        "(Optional) The folders you want to watch. Leave blank to watch for any new presentation in the Drive.",
    },
  },
  methods: {
    ...newFilesInstant.methods,
    shouldProcess(file) {
      return (
        file.mimeType.includes("presentation") &&
        newFilesInstant.methods.shouldProcess.bind(this)(file)
      );
    },
    getPresentationsFromFolderOpts(folderId) {
      const mimeQuery = "mimeType = 'application/vnd.google-apps.presentation'";
      let opts = {
        q: `${mimeQuery} and parents in '${folderId}' and trashed = false`,
      };
      if (!this.isMyDrive()) {
        opts = {
          corpora: "drive",
          driveId: this.getDriveId(),
          includeItemsFromAllDrives: true,
          supportsAllDrives: true,
          ...opts,
        };
      }
      return opts;
    },
    async getPresentations(limit) {
      const slides = [];
      const foldersIds = this.folders;
      for (const folderId of foldersIds) {
        const opts = this.getPresentationsFromFolderOpts(folderId);
        const filesWrapper = await this.googleDrive.listFilesInPage(null, opts);
        for (const file of filesWrapper.files) {
          const fileInfo = await this.googleDrive.getFile(file.id);
          slides.push(fileInfo);
          if (slides.length >= limit) { return slides; }
        }
      }
      return slides;
    },
  },
};

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
Google DrivegoogleDriveappThis component uses the Google Drive app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
DrivedrivestringSelect a value from the drop down menu.
Foldersfoldersstring[]Select a value from the drop down menu.

Trigger Authentication

Google Drive uses OAuth authentication. When you connect your Google Drive account, Pipedream will open a popup window where you can sign into Google Drive and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Google Drive API.

Pipedream requests the following authorization scopes when you connect your account:

https://www.googleapis.com/auth/drive

About Google Drive

Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.

Action

Description:Performs a search using the Serphouse API. [See the documentation](https://docs.serphouse.com/serp-api/live-using-http-get-method)
Version:0.0.1
Key:serphouse-perform-search

SERPhouse Overview

The SERPhouse API provides a way to fetch real-time search engine results pages (SERPs) from Google and Bing. With it, you can gather SEO data, monitor keyword rankings, and gain insights into search trends. On Pipedream, you can leverage this API to build serverless workflows that automate SEO tasks, conduct competitive analysis, and integrate with other apps to enhance your digital marketing strategies.

Action Code

import serphouse from "../../serphouse.app.mjs";
import { ConfigurationError } from "@pipedream/platform";

export default {
  key: "serphouse-perform-search",
  name: "Perform Search",
  description: "Performs a search using the Serphouse API. [See the documentation](https://docs.serphouse.com/serp-api/live-using-http-get-method)",
  version: "0.0.1",
  type: "action",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  props: {
    serphouse,
    query: {
      propDefinition: [
        serphouse,
        "query",
      ],
    },
    domain: {
      propDefinition: [
        serphouse,
        "domain",
      ],
    },
    language: {
      propDefinition: [
        serphouse,
        "language",
        ({ domain }) => ({
          domain,
        }),
      ],
    },
    device: {
      type: "string",
      label: "Device",
      description: "The device to use for the search",
      options: [
        "desktop",
        "tablet",
        "mobile",
      ],
    },
    serpType: {
      type: "string",
      label: "SERP Type",
      description: "The type of SERP to use for the search",
      options: [
        "web",
        "news",
        "image",
      ],
    },
    locationAlert: {
      propDefinition: [
        serphouse,
        "locationAlert",
      ],
    },
    locationId: {
      propDefinition: [
        serphouse,
        "locationId",
        ({ domain }) => ({
          domain,
        }),
      ],
      optional: true,
    },
    verbatim: {
      type: "boolean",
      label: "Verbatim",
      description: "If true, the search will be performed verbatim",
      optional: true,
    },
    gfilter: {
      type: "boolean",
      label: "GFilter",
      description: "Parameter defines if the filters for 'Similar Results' and 'Omitted Results' are on or off. It can be set to `true` (default) to enable these filters, or `false` to disable these filters.",
      optional: true,
      default: true,
    },
    page: {
      type: "integer",
      label: "Page",
      description: "Give specific page to get the result of that page number. By default it will get you first page",
      optional: true,
    },
    numResults: {
      type: "integer",
      label: "Number of Results",
      description: "Define number of result you want to get per page. By default you will get top 100 results.",
      optional: true,
    },
    dateRange: {
      propDefinition: [
        serphouse,
        "dateRange",
      ],
    },
  },
  async run({ $ }) {
    const type = this.serphouse.getDomainType(this.domain);
    if (!this.locationId && (type === "google" || type === "bing")) {
      throw new ConfigurationError("Location is required for Google and Bing searches");
    }
    const response = await this.serphouse.performSearch({
      $,
      params: {
        q: this.query,
        domain: this.domain,
        lang: this.language,
        device: this.device,
        serp_type: this.serpType,
        loc_id: this.locationId,
        verbatim: this.verbatim
          ? "1"
          : "0",
        gfilter: this.gfilter
          ? "1"
          : "0",
        page: this.page,
        num_result: this.numResults,
        date_range: this.dateRange,
      },
    });
    if (response.status === "success") {
      $.export("$summary", `Successfully performed search for "${this.query}".`);
    }
    return response;
  },
};

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
SERPhouseserphouseappThis component uses the SERPhouse app.
Queryquerystring

Search phrase that you want to search

DomaindomainstringSelect a value from the drop down menu.
LanguagelanguagestringSelect a value from the drop down menu.
DevicedevicestringSelect a value from the drop down menu:desktoptabletmobile
SERP TypeserpTypestringSelect a value from the drop down menu:webnewsimage
LocationlocationIdstringSelect a value from the drop down menu.
Verbatimverbatimboolean

If true, the search will be performed verbatim

GFiltergfilterboolean

Parameter defines if the filters for 'Similar Results' and 'Omitted Results' are on or off. It can be set to true (default) to enable these filters, or false to disable these filters.

Pagepageinteger

Give specific page to get the result of that page number. By default it will get you first page

Number of ResultsnumResultsinteger

Define number of result you want to get per page. By default you will get top 100 results.

Date RangedateRangestringSelect a value from the drop down menu:{ "label": "Past hour", "value": "h" }{ "label": "Past 24 hours", "value": "d" }{ "label": "Past week", "value": "w" }{ "label": "Past month", "value": "m" }{ "label": "Past year", "value": "y" }

Action Authentication

SERPhouse uses API keys for authentication. When you connect your SERPhouse account, Pipedream securely stores the keys so you can easily authenticate to SERPhouse APIs in both code and no-code steps.

About SERPhouse

High Volume API for SEO companies, data mining services, and SEO Tool Suite as a SaaS.

More Ways to Connect SERPhouse + Google Drive

Google Jobs Search with SERPhouse API on New Presentation (Instant) from Google Drive API
Google Drive + SERPhouse
 
Try it
Google Jobs Search with SERPhouse API on New Access Proposal from Google Drive API
Google Drive + SERPhouse
 
Try it
Google Jobs Search with SERPhouse API on New Shared Drive from Google Drive API
Google Drive + SERPhouse
 
Try it
Perform Search with SERPhouse API on New Access Proposal from Google Drive API
Google Drive + SERPhouse
 
Try it
Perform Search with SERPhouse API on New Shared Drive from Google Drive API
Google Drive + SERPhouse
 
Try it
Changes to Files in Drive from the Google Drive API

Emit new event when a change is made to one of the specified files. See the documentation

 
Try it
Changes to Specific Files from the Google Drive API

Watches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to shared drive files, use the Changes to Specific Files (Shared Drive) source instead.

 
Try it
Changes to Specific Files (Shared Drive) from the Google Drive API

Watches for changes to specific files in a shared drive, emitting an event when a change is made to one of those files

 
Try it
New Access Proposal from the Google Drive API

Emit new event when a new access proposal is requested in Google Drive

 
Try it
New Files (Instant) from the Google Drive API

Emit new event when a new file is added in your linked Google Drive

 
Try it
Add Comment with the Google Drive API

Add an unanchored comment to a Google Doc (general feedback, no text highlighting). See the documentation

 
Try it
Copy File with the Google Drive API

Create a copy of the specified file. See the documentation for more information

 
Try it
Create Folder with the Google Drive API

Create a new empty folder. See the documentation for more information

 
Try it
Create New File From Template with the Google Drive API

Create a new Google Docs file from a template. Optionally include placeholders in the template document that will get replaced from this action. See documentation

 
Try it
Create New File From Text with the Google Drive API

Create a new file from plain text. See the documentation for more information

 
Try it

Explore Other Apps

1
-
24
of
3,000+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
AWS
AWS
Premium
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Premium
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Klaviyo
Klaviyo
Premium
Klaviyo unifies your data, channels, and AI agents in one platform—text, WhatsApp, email marketing, and more—driving growth with every interaction.
Zendesk
Zendesk
Premium
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
Premium
Beta
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.