import { PubSub } from "@google-cloud/pubsub";
import {
axios,
ConfigurationError,
DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
} from "@pipedream/platform";
import { v4 as uuidv4 } from "uuid";
import gmail from "../../gmail.app.mjs";
import common from "../common/polling-history.mjs";
import verifyClient from "../common/verify-client-id.mjs";
export default {
...common,
key: "gmail-new-email-received",
name: "New Email Received",
description: "Emit new event when a new email is received.",
type: "source",
version: "0.3.0",
dedupe: "unique",
props: {
gmail,
db: "$.service.db",
triggerType: {
type: "string",
label: "Trigger Type",
options: [
"polling",
"webhook",
],
description:
"Configuring this source as a `webhook` (instant) trigger requires a custom OAuth client. [Refer to the guide here to get started](https://pipedream.com/apps/gmail/#getting-started).",
reloadProps: true,
optional: true,
default: "polling",
},
timer: {
type: "$.interface.timer",
label: "Polling Interval",
description: "How often to poll for new emails",
default: {
intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
},
},
withTextPayload: {
type: "boolean",
label: "Return payload as plaintext",
description: "Convert the payload response into a single text field. **This reduces the size of the payload and makes it easier for LLMs work with.**",
default: false,
},
serviceAccountKeyJson: {
type: "string",
label: "Service Account Key JSON",
optional: true,
hidden: true,
reloadProps: true,
},
serviceAccountKeyJsonInstructions: {
type: "alert",
alertType: "info",
content: `1) [Create a service account in GCP](https://cloud.google.com/iam/docs/creating-managing-service-accounts) and set the following permission: **Pub/Sub Admin**
\n2) [Generate a service account key](https://cloud.google.com/iam/docs/creating-managing-service-account-keys)
\n3) Download the key details in JSON format
\n4) Open the JSON in a text editor, and **copy and paste its contents here**.
`,
hidden: true,
},
topicType: {
type: "string",
label: "Pub/Sub Topic",
description:
"Do you have an existing Pub/Sub topic, or would you like to create a new one?",
options: [
"existing",
"new",
],
optional: true,
hidden: true,
reloadProps: true,
},
topic: {
type: "string",
label: "Pub/Sub Topic Name",
description: "Select a Pub/Sub topic from your GCP account to watch",
async options() {
return this.getTopics();
},
optional: true,
hidden: true,
reloadProps: true,
},
labels: {
propDefinition: [
gmail,
"label",
],
type: "string[]",
label: "Labels",
default: [
"INBOX",
],
optional: true,
},
excludeLabels: {
propDefinition: [
gmail,
"label",
],
type: "string[]",
label: "Exclude Labels",
description: "Emails with the specified labels will be excluded from results",
optional: true,
},
permissionAlert: {
type: "alert",
alertType: "error",
content: `Unable to grant publish permission to Gmail API service account.
\n1. Navigate to your [Google Cloud PubSub Topics List](https://console.cloud.google.com/cloudpubsub)
\n2. Select "View Permissions" for the topic you intend to use for this source.
\n3. Click "ADD PRINCIPAL"
\n4. Select "Pub/Sub Publisher" for the Role.
\n5. Enter \`serviceAccount:gmail-api-push@system.gserviceaccount.com\` as the principal.
\n6. Click "Save"
`,
hidden: true,
},
latencyWarningAlert: {
type: "alert",
alertType: "warning",
content:
"Please allow up to 1 minute for deployment. We're setting up your real-time email notifications behind the scenes.",
hidden: true,
},
},
async additionalProps() {
const newProps = {};
if (this.triggerType === "webhook") {
const isValidClientId = await this.checkClientId();
if (!isValidClientId) {
throw new ConfigurationError(
"Configuring this source as a `webhook` (instant) trigger requires a custom OAuth client. [Refer to the guide here to get started](https://pipedream.com/apps/gmail/#getting-started).",
);
}
newProps.http = {
type: "$.interface.http",
customResponse: true,
};
newProps.timer = {
type: "$.interface.timer",
static: {
intervalSeconds: 60 * 60,
},
hidden: true,
};
newProps.serviceAccountKeyJson = {
type: "string",
label: "Service Account Key JSON",
hidden: false,
optional: false,
reloadProps: true,
};
newProps.serviceAccountKeyJsonInstructions = {
type: "alert",
alertType: "info",
content: `1) [Create a service account in GCP](https://cloud.google.com/iam/docs/creating-managing-service-accounts) and set the following permission: **Pub/Sub Admin**
\n2) [Generate a service account key](https://cloud.google.com/iam/docs/creating-managing-service-account-keys)
\n3) Download the key details in JSON format
\n4) Open the JSON in a text editor, and **copy and paste its contents here**.
`,
hidden: false,
};
newProps.topicType = {
type: "string",
label: "Pub/Sub Topic",
description: "Do you have an existing Pub/Sub topic, or would you like to create a new one?",
options: [
"existing",
"new",
],
hidden: false,
optional: false,
reloadProps: true,
};
if (!this.serviceAccountKeyJson || !this.topicType) {
return newProps;
}
try {
const authKeyJSON = JSON.parse(this.serviceAccountKeyJson);
if (this.topicType === "new") {
const { project_id: projectId } = authKeyJSON;
const topicName = `projects/${projectId}/topics/${this.convertNameToValidPubSubTopicName(
uuidv4(),
)}`;
newProps.topic = {
type: "string",
default: topicName,
hidden: true,
};
this._topicName = topicName;
} else if (this.topicType === "existing") {
newProps.topic = {
type: "string",
label: "Pub/Sub Topic Name",
description: "Select a Pub/Sub topic from your GCP account to watch",
options: async () => {
try {
const sdkParams = {
credentials: {
client_email: authKeyJSON.client_email,
private_key: authKeyJSON.private_key,
},
projectId: authKeyJSON.project_id,
};
const pubSubClient = new PubSub(sdkParams);
const topics = (await pubSubClient.getTopics())[0];
if (topics.length > 0) {
return topics.map((topic) => topic.name);
}
return [];
} catch (err) {
console.log("Error fetching topics:", err);
return [];
}
},
hidden: false,
optional: false,
reloadProps: true,
};
}
} catch (err) {
console.log("Error with service account key JSON:", err);
newProps.serviceAccountKeyJsonError = {
type: "alert",
alertType: "error",
content: "Invalid service account key JSON. Please check your input and try again.",
hidden: false,
};
return newProps;
}
if ((this.topic && this.topicType === "existing") || this.topicType === "new") {
try {
const topicName = this.topicType === "new"
? this._topicName
: this.topic;
if (!topicName) {
return newProps;
}
const topic = await this.getOrCreateTopic(topicName);
let hasPublisherRole;
try {
const [
policy,
] = await topic.iam.getPolicy();
hasPublisherRole = policy.bindings.find(
({
members, role,
}) =>
members.includes(
"serviceAccount:gmail-api-push@system.gserviceaccount.com",
) && role === "roles/pubsub.publisher",
);
} catch (err) {
console.log("Could not retrieve iam policy:", err);
}
if (!hasPublisherRole) {
try {
await topic.iam.setPolicy({
bindings: [
{
role: "roles/pubsub.publisher",
members: [
"serviceAccount:gmail-api-push@system.gserviceaccount.com",
],
},
],
});
console.log("Permissions granted to Gmail API service account.");
} catch (err) {
console.log("Could not set permission:", err);
newProps.permissionAlert = {
type: "alert",
alertType: "error",
content: `Unable to grant publish permission to Gmail API service account.
\n1. Navigate to your [Google Cloud PubSub Topics List](https://console.cloud.google.com/cloudpubsub)
\n2. Select "View Permissions" for the topic you intend to use for this source.
\n3. Click "ADD PRINCIPAL"
\n4. Select "Pub/Sub Publisher" for the Role.
\n5. Enter \`serviceAccount:gmail-api-push@system.gserviceaccount.com\` as the principal.
\n6. Click "Save"
`,
hidden: false,
};
return newProps;
}
}
newProps.latencyWarningAlert = {
type: "alert",
alertType: "warning",
content:
"Please allow up to 1 minute for deployment. We're setting up your real-time email notifications behind the scenes.",
hidden: false,
};
try {
const {
historyId, expiration,
} = await this.setupGmailNotifications(topicName);
newProps.initialHistoryId = {
type: "string",
default: historyId,
hidden: true,
};
newProps.expiration = {
type: "string",
default: expiration,
hidden: true,
};
} catch (err) {
console.log("Error setting up Gmail notifications:", err);
return newProps;
}
} catch (err) {
console.log("Error with topic setup:", err);
return newProps;
}
}
}
return newProps;
},
hooks: {
...common.hooks,
async activate() {
if (this.triggerType !== "webhook") {
return;
}
const sdkParams = this.sdkParams();
const pubSubClient = new PubSub(sdkParams);
const currentTopic = {
name: this.topic,
};
const pushEndpoint = this.http.endpoint;
const subscriptionName =
this.convertNameToValidPubSubTopicName(pushEndpoint);
const subscriptionOptions = {
pushConfig: {
pushEndpoint,
},
};
const [
subscriptionResult,
] = await pubSubClient
.topic(currentTopic.name)
.createSubscription(subscriptionName, subscriptionOptions);
this._setSubscriptionName(subscriptionResult.name);
},
async deactivate() {
if (this.triggerType !== "webhook") {
return;
}
const sdkParams = this.sdkParams();
const pubSubClient = new PubSub(sdkParams);
const subscriptionName = this._getSubscriptionName();
if (subscriptionName) {
await pubSubClient.subscription(subscriptionName).delete();
}
},
},
methods: {
...verifyClient.methods,
...common.methods,
_getTopicName() {
return this.db.get("topicName");
},
_setTopicName(topicName) {
this.db.set("topicName", topicName);
},
_getSubscriptionName() {
return this.db.get("subscriptionName");
},
_setSubscriptionName(subscriptionName) {
this.db.set("subscriptionName", subscriptionName);
},
_getLastProcessedHistoryId() {
return this.db.get("lastProcessedHistoryId");
},
_setLastProcessedHistoryId(lastProcessedHistoryId) {
this.db.set("lastProcessedHistoryId", lastProcessedHistoryId);
},
_getExpiration() {
return this.db.get("expiration");
},
_setExpiration(expiration) {
this.db.set("expiration", expiration);
},
_getLastReceivedTime() {
return this.db.get("lastReceivedTime");
},
_setLastReceivedTime(lastReceivedTime) {
this.db.set("lastReceivedTime", lastReceivedTime);
},
sdkParams() {
try {
const authKeyJSON = JSON.parse(this.serviceAccountKeyJson);
const {
project_id: projectId, client_email, private_key,
} = authKeyJSON;
if (!projectId || !client_email || !private_key) {
throw new Error("Missing required fields in service account key JSON");
}
const sdkParams = {
credentials: {
client_email,
private_key,
},
projectId,
};
return sdkParams;
} catch (error) {
console.log("Error parsing service account key:", error);
throw new ConfigurationError("Invalid service account key JSON. Please check your input and try again.");
}
},
async getTopics() {
try {
const sdkParams = this.sdkParams();
const pubSubClient = new PubSub(sdkParams);
const topics = (await pubSubClient.getTopics())[0];
if (topics.length > 0) {
return topics.map((topic) => topic.name);
}
return [];
} catch (error) {
console.log("Error fetching topics:", error);
return [];
}
},
convertNameToValidPubSubTopicName(name) {
return (
name
.replace(/(^goog.*)/g, "pd-$1")
.replace(/^(?![a-zA-Z]+)/, "pd-")
.replace(/[^a-zA-Z0-9_\-.~+%]+/g, "-")
);
},
makeRequest({
$ = this, path, ...opts
}) {
return axios($, {
url: `https://gmail.googleapis.com/gmail/v1${path}`,
headers: {
Authorization: `Bearer ${this.gmail.getToken()}`,
},
...opts,
});
},
async setupGmailNotifications(topicName) {
const watchResponse = await this.makeRequest({
method: "POST",
path: "/users/me/watch",
data: {
topicName,
labelIds: this.labels || [
"INBOX",
],
},
});
console.log("Watch response:", watchResponse);
return watchResponse;
},
async getOrCreateTopic(name) {
try {
const sdkParams = this.sdkParams();
const pubSubClient = new PubSub(sdkParams);
let topicName;
if (name) {
topicName = name;
} else if (this.topicType === "new" && this._topicName) {
topicName = this._topicName;
} else {
topicName = this.topic;
}
if (!topicName) {
throw new Error("No topic name provided");
}
let topic;
try {
[
topic,
] = await pubSubClient.createTopic(topicName);
console.log(`Topic ${topicName} created.`);
} catch (error) {
if (error.code === 6) {
console.log(`Topic ${topicName} already exists.`);
topic = pubSubClient.topic(topicName);
} else {
throw error;
}
}
return topic;
} catch (error) {
console.log("Error in getOrCreateTopic:", error);
throw error;
}
},
getHistoryTypes() {
return [
"messageAdded",
];
},
generateMeta(message) {
return {
id: message.id,
summary: message.snippet,
ts: +message.internalDate,
};
},
filterHistory(history) {
let filteredHistory = history.filter((item) => item.messagesAdded?.length);
if (this.labels) {
filteredHistory = filteredHistory.filter((item) =>
item.messagesAdded[0].message.labelIds &&
item.messagesAdded[0].message.labelIds.some((i) => this.labels.includes(i)));
}
if (this.excludeLabels) {
filteredHistory = filteredHistory.filter((item) =>
item.messagesAdded[0].message.labelIds &&
!(item.messagesAdded[0].message.labelIds.some((i) => this.excludeLabels.includes(i))));
}
return filteredHistory;
},
async getMessageDetails(ids) {
const messages = await Promise.all(ids.map(async (id) => {
try {
const message = await this.gmail.getMessage({
id,
});
return message;
} catch {
console.log(`Could not find message ${id}`);
return null;
}
}));
return messages;
},
async getHistoryResponses(startHistoryId) {
const historyResponses = [];
for (const labelId of this.labels) {
const response = await this.gmail.listHistory({
startHistoryId,
historyTypes: [
"messageAdded",
],
labelId,
});
historyResponses.push(response);
}
return historyResponses;
},
},
async run(event) {
if (this.triggerType !== "webhook") {
let lastHistoryId = this._getLastHistoryId();
if (!lastHistoryId) {
lastHistoryId = await this.getHistoryId();
}
await this.emitHistories(lastHistoryId);
return;
}
if (this.triggerType === "webhook") {
if (event.timestamp) {
const topicName = this._getTopicName();
if (topicName) {
const currentExpiration = this._getExpiration();
const lastReceivedTime = this._getLastReceivedTime();
if (
(+currentExpiration < (event.timestamp + 3600) * 1000)
|| (lastReceivedTime < (event.timestamp - 3600) * 1000)
) {
const { expiration } = await this.setupGmailNotifications(topicName);
this._setExpiration(expiration);
}
return;
} else {
this._setTopicName(this.topic);
const initialHistoryId = this.initialHistoryId || this._getLastHistoryId();
this._setLastProcessedHistoryId(initialHistoryId);
this._setExpiration(this.expiration);
return;
}
}
this.http.respond({
status: 200,
});
const pubsubMessage = event.body.message;
if (!pubsubMessage) {
return;
}
const decodedData = JSON.parse(
Buffer.from(pubsubMessage.data, "base64").toString(),
);
console.log("Decoded Pub/Sub data:", decodedData);
const { historyId: receivedHistoryId } = decodedData;
const lastProcessedHistoryId = this._getLastProcessedHistoryId();
console.log("Last processed historyId:", lastProcessedHistoryId);
let startHistoryId = Math.min(
parseInt(lastProcessedHistoryId),
parseInt(receivedHistoryId),
);
console.log("Using startHistoryId:", startHistoryId);
let historyResponses;
try {
historyResponses = await this.getHistoryResponses(startHistoryId);
} catch {
await this.emitRecentMessages();
startHistoryId = parseInt(receivedHistoryId);
console.log("Using startHistoryId:", startHistoryId);
historyResponses = await this.getHistoryResponses(startHistoryId);
}
console.log(
"History responses:",
JSON.stringify(historyResponses, null, 2),
);
const newMessages = [];
for (const historyResponse of historyResponses) {
if (historyResponse.history) {
const historyResponseFiltered = this.filterHistory(historyResponse.history);
for (const historyItem of historyResponseFiltered) {
newMessages.push(
...historyItem.messagesAdded.map((msg) => msg.message),
);
}
}
}
console.log("New messages found:", newMessages.length);
const newMessageIds = newMessages?.map(({ id }) => id) || [];
const messageDetails = await this.getMessageDetails(newMessageIds);
if (!messageDetails?.length) {
return;
}
console.log("Fetched message details count:", messageDetails.length);
let latestHistoryId = receivedHistoryId;
for (const historyResponse of historyResponses) {
latestHistoryId = Math.max(latestHistoryId, historyResponse.historyId);
}
this._setLastProcessedHistoryId(latestHistoryId);
console.log("Updated lastProcessedHistoryId:", latestHistoryId);
this._setLastReceivedTime(Date.now());
messageDetails.forEach((message) => {
if (message?.id) {
this.emitEvent(message);
}
});
}
},
};
Chase Roberts@chsrbrts@benedictevans If you haven’t used @pipedream yet, then you haven’t lived.
✨Ellie Day✨@heyelliedayEvaluation update: @pipedream has quite literally been a dream to work with! I’m excited to leverage this tool for all the various workflows I need to write. I’m currently at 11k invocations a day from the initial workflows I’ve written in the past couple weeks.
Michael Braedley@MBraedleyUpdate: I got it working properly, and it's working so well that I'm dropping IFTTT. @pipedream can do everything that IFTTT basic can, and most (if not all things) IFTTT pro can for free or at a reasonable price if you need it. I am recommending it for basically any power user.
Thomas Cutting@mrthomascuttingWant quick+dirty integrations for a serverless workflow - @pipedream is my new go-to 😃
Matthew Roberts@mattdotrobertsday 013 - finally hit node js. This is the secret sauce of taking #nocode projects that one step further. Pumped about getting deeper into @pipedream now
Kenneth Auchenberg 💭@auchenbergYahoo Pipes is back! Kinda 😍 @pipedream
Raymond Camden 🥑@raymondcamdenAwesome video by the @pipedream folks showing real time twitter sentiment analysis integrated with Google Sheets. This is where Pipedream *really* shines, connecting systems together in easy workflows.
Nacho Caballero@nachocaballeroI couldn't recommend @pipedream more. It's an amazing service to integrate different APIs. Much more powerful than Zapier and more user-friendly than AWS Lambda. I'm very proud to wear this t-shirt #NoCode
Jason Snow@jyksnwDeveloped a working prototype environmental sensor IoT solution with @particle Photon, @pipedream, and @MongoDB with full graphing and alerting in less than a day! All amazing technology, will def. be exploring these more.
Steven Terrana@steven_terrana@burgwyn you've inspired me to finally set up my own blog. I'll make sure my first blog post explains the tech behind the setup. think @obsdmd + @GatsbyJS + @pipedream.
🚄 James Augeri, PhD@DotDotJamesWant to low-code your back end, need more horsepower than @Bubble / @KnackHQ, or just miss Yahoo! Pipes? Check out @PipeDream
Sébastien Chopin@AtinuxGitHub issues should be like @linear_app for maintainers. Looking forward more integrations with GH actions or tools like @pipedream 👀
Raul@raul_predescuIf you're a dev and not using @pipedream, you're missing out. Been using it for months, daily. FREE for devs. Plenty of integrations and good limits. Absolutely love it.
Bruno Skvorc@bitfallsSo @pipedream is pretty amazing. In 3 minutes I just made a flow which adds @rickastley's Never Gonna Give You Up to my @spotify playlist whenever a new pull request arrives in an old repo of mine.
Zach Lanich@ZachLanichUm, wow 🤯 @pipedream
Steven Bell@bellontechI just used @pipedream to build a Shopify App. Wow, they make small backed tasks easy.
Jay Hack 🎩🇺🇸@_jayhack_Very impressed with this bad boi - it reminds me of a @PalantirTech internal tool, but geared towards integrations instead of data analysis and far more customizable. Great expectations here 🚀🤩
Tree Sturgeon 🔥🚴♂️🌳@philsturgeonFor context this is day 2 of a really challenging and stupid migration from Notion to @airtable with disparate/missing data. It's going better than expected and thanks to @pipedream I don't have to bother the iOS dev to add W3W.