This topic was automatically generated from Slack. You can find the original thread here.
I need help with creating an item with email into a monday.com board.
To create an item with an email into a monday.com board, you’ll need to use the monday.com API to create the item and associate it with the email. Below is an example Pipedream component that demonstrates how you can achieve this: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { monday: { type: "app", app: "monday", }, }, async run({ steps, $ }) { const boardId = YOUR_MONDAY_BOARD_ID; // Replace with your actual board ID const groupId = YOUR_MONDAY_GROUP_ID; // Replace with your actual group ID const itemName = "Item from email"; // Replace with the item name you want to create const columnValues = JSON.stringify({ email: "[example@email.com](mailto:example@email.com)", // Replace with the actual email value // Add other column values here }); const data = { query: `mutation { create_item (board_id: ${boardId}, group_id: "${groupId}", item_name: "${itemName}", column_values: "${columnValues}") { id } }`, }; return await axios($, { method: "POST", url: `https://api.monday.com/v2`, headers: { "Authorization": `${this.monday.$auth.api_key}`, "Content-Type": "application/json", }, data, }); }, }); Please replace YOUR_MONDAY_BOARD_ID, YOUR_MONDAY_GROUP_ID, and the email value with the actual values you want to use. You can also add other column values as needed. Remember to connect your monday.com account to the Pipedream component by using the monday prop, which allows you to authorize requests to the monday.com API. If you need further assistance or have any questions, feel free to visit Pipedream Support.
I get this error when saving an item into monday.com board with email:
Failed to create item: invalid value, please check our API documentation for the correct data structure for this column. https://developer.monday.com/api-reference/docs/change-column-values
No results found
It seems like you’re encountering an issue with saving an item to a monday.com board using an email column. To help you further, could you please provide the following information: 1. The structure of the data you’re trying to send to monday.com, especially the value for the email column. 2. The specific Pipedream workflow code or component you’re using to make the request to monday.com. This information will help me understand the context better and assist you in resolving the error.
I am using the Pipedream’s pre-built action for creating an item.
This is the email I am trying to save: [zhii1234567@gmail.com](mailto:zhii1234567@gmail.com)
Based on your question, it seems you are looking to use a pre-built action within Pipedream to create an item that includes an email address. However, the specific details of the action you’re trying to use or the item you’re trying to create are not clear from your message. Could you please provide more information about the following: 1. Which pre-built action are you using? (e.g., a specific app’s action like Trello, Airtable, etc.) 2. What kind of item are you trying to create? (e.g., a task, a database entry, etc.) 3. Where exactly are you trying to save the email address? (e.g., in a specific field of a form, as part of a database record, etc.) This additional information will help me provide you with a more accurate and helpful response.
- monday.com
- Create Item
- Specific column, the Email column.
Based on your question, it seems you are looking to create an item in a specific column on monday.com, specifically targeting an Email column. To achieve this, you can use a Pipedream workflow with a monday.com action. Unfortunately, I do not have a direct link to a pre-built monday.com “Create Item” action, but I can provide you with a Node.js code example that you can use in a Pipedream workflow to create an item with an email value in a specific column. Here’s an example of how you can write a Pipedream component to create an item in a specific column on monday.com: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { monday: { type: "app", app: "monday", }, }, async run({ steps, $ }) { const boardId = 123456789; // Replace with your actual board ID const groupId = "group_id"; // Replace with your actual group ID const itemName = "New Item"; // Replace with the desired item name const emailColumnId = "email_column_id"; // Replace with your actual Email column ID const emailValue = "[example@example.com](mailto:example@example.com)"; // Replace with the actual email value you want to set // Construct the mutation for creating an item const mutation = `mutation { create_item (board_id: ${boardId}, group_id: "${groupId}", item_name: "${itemName}", column_values: "{\"${emailColumnId}\": \"${emailValue}\"}") { id } }`; // Make the API request to [monday.com](http://monday.com) return await axios($, { method: "POST", url: `https://api.monday.com/v2`, headers: { Authorization: `${this.monday.$auth.api_key}`, "Content-Type": "application/json", }, data: { query: mutation, }, }); }, }); Please replace the placeholders (boardId, groupId, itemName, emailColumnId, and emailValue) with your actual values. This code will create a new item on the specified board and group, with the email set in the specified Email column. If you need further assistance or have any other questions, feel free to visit Pipedream Support.
Thanks!
It appears that you’ve sent a message with the word “Thanks!” but without a specific question or context. If you have any questions or need assistance with Pipedream, please feel free to ask, and I’ll be happy to help! If you’re experiencing any issues or need further support, you can visit Pipedream Support.
I need help populating some Google Docs Template with images and texts. How can I do that in Pipedream using the Google Docs API?
To populate a Google Docs template with images and text using the Google Docs API in Pipedream, you’ll need to use the Google Docs API to create and update documents. Below is an example of how you might structure a Pipedream component to insert text into a Google Doc. Please note that inserting images is more complex and would require uploading the image to Google Drive and then inserting it into the document using its Drive URL. For detailed steps on how to work with images, please refer to the Google Docs API documentation. Here’s a basic example of how to insert text into a Google Doc: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, documentId: { type: "string", label: "Document ID", description: "The ID of the Google Doc you want to update.", }, content: { type: "string", label: "Content", description: "The text content you want to insert into the Google Doc.", }, }, async run({ steps, $ }) { const requestBody = { requests: [ { insertText: { location: { index: 1, // This example inserts text at the beginning of the document }, text: this.content, }, }, // Add additional requests here to insert more content or images ], }; return await axios($, { method: "POST", url: `https://docs.googleapis.com/v1/documents/${this.documentId}:batchUpdate`, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, "Content-Type": "application/json", }, data: requestBody, }); }, }); This code defines a Pipedream component with two props: documentId for the Google Doc ID and content for the text to insert. The run method sends a POST request to the Google Docs API’s batchUpdate method to insert the text at the beginning of the document. Please replace the index value with the correct location in your document where you want to insert the text or images. For more complex operations like inserting images, you’ll need to follow the Google Docs API documentation closely, as it requires several steps to upload the image to
Could you please make the documentId prop automatically populated with the list of Documents from the connect Google Account?
To automatically populate the documentId prop with a list of documents from the connected Google account, you can use an async options method within the prop definition. This method will make an API call to Google Drive to fetch the list of documents and return them as options for the user to select from in the Pipedream UI. Here’s an example of how you might define the documentId prop with an async options method: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, documentId: { type: "string", label: "Document", description: "Select a document from your Google Drive", async options({ page, prevContext }) { const { nextPageToken } = prevContext; const response = await axios($, { url: `https://www.googleapis.com/drive/v3/files`, params: { pageSize: 20, pageToken: page ? nextPageToken : undefined, q: "mimeType='application/vnd.google-apps.document'", }, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); // Map over the items and return an array of label/value objects const options = response.files.map((file) => ({ label: file.name, value: file.id, })); // Return options and the nextPageToken if there are more pages of results return { options, context: { nextPageToken: response.nextPageToken }, }; }, }, }, async run({ steps, $ }) { // The rest of your component code goes here }, }); In this example, the async options method makes a call to the Google Drive API to list the files with the MIME type for Google Docs (application/vnd.google-apps.document). It then maps over the results to create an array of options with the document names as labels and their IDs as values. The method also handles pagination by using the nextPageToken from the API response. Please note that you’ll need to adjust the q parameter in the API request to filter for the specific type of documents you want to list, and you may need to handle additional pagination logic depending on the number of documents in the user’s
Could you please make the documentId prop automatically populated with the list of Documents from the connected Google Docs Account?
To automatically populate the documentId prop with a list of documents from the connected Google Docs account, you would define an async options method within the prop definition. This method will make an API call to Google Docs to fetch the list of documents and return them in the format expected by Pipedream. Here’s how you can implement this in a Pipedream component: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, documentId: { type: "string", label: "Document", description: "Select a document from your Google Docs account", async options({ page, prevContext }) { const { nextPageToken } = prevContext; const response = await axios($, { url: `https://www.googleapis.com/drive/v3/files`, params: { q: "mimeType='application/vnd.google-apps.document'", fields: "nextPageToken, files(id, name)", pageToken: page > 1 ? nextPageToken : undefined, }, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); // Map the files to the label/value format expected by Pipedream const options = response.files.map((file) => ({ label: file.name, value: file.id, })); return { options, context: { nextPageToken: response.nextPageToken }, }; }, }, }, async run({ steps, $ }) { // You can now use this.documentId in your API requests }, }); This code snippet adds a documentId prop to your component, which fetches the list of Google Docs documents and presents them as options to the user. When the user configures the component, they will be able to select a document from a dropdown menu populated with their documents. Please note that the q parameter in the API request is used to filter for Google Docs documents. The fields parameter specifies that we only want to fetch the id and name of each file, along with the nextPageToken for pagination purposes. Remember to visit Pipedream’s Google app integration documentation for more details on using Google services
please use Google Docs App (google_docs) not Google (google)
Based on your request to use the Google Docs app (google_docs) and not Google (google), here is an example Pipedream component that makes a test request against the Google Docs API using the Google Docs app: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google_docs: { type: "app", app: "google_docs", }, }, async run({ steps, $ }) { return await axios($, { url: `https://www.googleapis.com/oauth2/v1/userinfo`, headers: { Authorization: `Bearer ${this.google_docs.$auth.oauth_access_token}`, }, }); }, }); This component will authorize requests to the Google Docs API using OAuth. The this.google_docs.$auth.oauth_access_token is used to authenticate the request. If you need more information on how to use the Google Docs app on Pipedream, please refer to the documentation: Using the Google Docs app.
Thanks, now, using google_docs account please add a prop named documentId and then automatically populate it with the existing Google Docs IDs from the connected Google Docs Account (google_docs).
import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google_docs: { type: "app", app: "google_docs", }, documentId: { type: "string", label: "Document ID", async options({ page, prevContext }) { const { nextPageToken } = prevContext; const response = await axios(this, { url: `https://www.googleapis.com/drive/v3/files`, params: { q: "mimeType='application/vnd.google-apps.document'", fields: "nextPageToken, files(id, name)", pageToken: page ? nextPageToken : undefined, }, headers: { Authorization: `Bearer ${this.google_docs.$auth.oauth_access_token}`, }, }); // Map the files to the label/value format expected by options const options = response.files.map((file) => ({ label: file.name, value: file.id, })); // Return options and the nextPageToken if there are more files to paginate through return { options, context: { nextPageToken: response.nextPageToken }, }; }, }, }, async run({ steps, $ }) { // You can use this.documentId in your code to reference the selected document ID }, });
``` This Pipedream component code includes a `documentId` prop that automatically populates with the existing Google Docs IDs from the connected Google Docs Account. The `options` method within the `documentId` prop makes a paginated request to the Google Drive API to list Google Docs files and formats them as options for the user to select in the Pipedream UI.