New Entry Recruitement
@nikolasboe
code:
data:privatelast updated:2 years ago
today
Build integrations remarkably fast!
You're viewing a public workflow template.
Sign up to customize, add steps, modify code and more.
Join 800,000+ developers using the Pipedream platform
steps.
get_values

Get all values from a sheet.

configure
steps.
format_embed_message
auth
to use OAuth tokens and API keys in code via theauths object
code
Write any Node.jscodeand use anynpm package. You can alsoexport datafor use in later steps via return or this.key = 'value', pass input data to your code viaparams, and maintain state across executions with$checkpoint.
async (event, steps) => {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
}
44
this.msg = [{
  "author": {
        "name": steps.get_values.$return_value[1][1]+" wurde grad hinzugefügt!",
        "url": steps.get_values.$return_value[1][0],
        //"icon_url": "https://i.imgur.com/R66g1Pe.jpg"
      },
      "title": "Battle-Tag: "+steps.get_values.$return_value[1][8],
      //"url": "https://google.com/",
      //"description": "Text message. You can use Markdown here. *Italic* **bold** __underline__ ~~strikeout~~ [hyperlink](https://google.com) `code`",
      "color": 0x0F9D58,
      "fields": [
        {
          "name": "Klasse",
          "value": steps.get_values.$return_value[1][3],
          "inline": true
        },
        {
          "name": "Rolle",
          "value": steps.get_values.$return_value[1][4],
          "inline": true
        },
        {
          "name": "Notiz",
          "value": steps.get_values.$return_value[1][13]
        }
        //,
        //{
        //  "name": "Thanks!",
        //  "value": "You're welcome :wink:"
        //}
      ],
      //"thumbnail": {
      //  "url": "https://upload.wikimedia.org/wikipedia/commons/3/38/4-Nature-Wallpapers-2014-1_ukaavUI.jpg"
      //},
      //"image": {
      //  "url": "https://upload.wikimedia.org/wikipedia/commons/5/5a/A_picture_from_China_every_day_108.jpg"
      //},
      "footer": {
        "text": "Hinzugefügt am: "+steps.get_values.$return_value[1][9],
        //"icon_url": "https://i.imgur.com/fKL31aD.jpg"
      }
}] 
steps.
send_message
Send a message to the channel tied to your incoming webhook. At least one of message OR embeds is required.
auth
(auths.discord_webhook)
params
Embeds
{{steps.format_embed_message.msg}}
array ·params.embeds
Optional
code
async (params, auths) => {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
}
23
const url = auths.discord_webhook.oauth_uid
let content = params.message
const { embeds, username, avatar_url } = params

if (!content && !embeds) {
  throw new Error("This action expects a message OR an embeds param. Please enter one or the other from the params menu above")
}

return await require("@pipedreamhq/platform").axios(this, {
  method: "POST",
  url,
  headers: {
    "Content-Type": "application/json"
  },
  data: {
    content,
    embeds,
    username,
    avatar_url,
  }
})