LUSHA x Gsheet

	A	B	C	D	E	F	G	I
1	Firstname	Lastname	Domain	Phone	Generate URL		COPY PASTE GSHEET PLEASE
2	Reed	Hastings	netflix.com	#NAME?	https://api.lusha.co/person?firstName=Reed&lastName=Hastings&domain=netflix.com
3							LIKE PLEASE	➡️
4	STEP 1						https://www.linkedin.com/feed/update/urn:li:activity:6892035382574153728/
5
6
7
8
9						WITH API KEY LUSHA
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26	STEP 2
27	function lusha(urlgenerate) { var response = UrlFetchApp.fetch(urlgenerate, { method: 'get', headers: { api_key: 'API LUSHA' }}); var json = response.getContentText(); var data = JSON.parse(json); return data.data.phoneNumbers[1].internationalNumber; }
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100