Collect LinkedIn Profiles with RapidAPI

Uses RapidAPI to collect LinkedIn profiles for an array of individuals (using their LI urls), extracts the values for some interesting keys, and then inserts them into a Google Sheet. <br>Do not contravene LinkedIn's Terms of Service, linked below.
Import Workflow

-------------------------------------------------------------------------------- subject: cranq.ai flow export version: 1.0 title: LinkedIn Profile Getter ------------------------------------ BEGIN ------------------------------------- eyJmbG93Ijp7ImlkIjoiaWQtMDAwMDAwIiwidGl0bGUiOiJMaW5rZWRJbiBQcm9maWxlIEdldHRlciIs ImRlc2NyaXB0aW9uIjoiVGFrZXMgYW4gYXJyYXkgb2YgTGlua2VkSW4gcHJvZmlsZSBVUkxzLCBhbmQg cXVlcmllcyBSYXBpZEFQSSB0byBnZXQgZnVsbCBkZXRhaWxzIG9uIGVhY2ggaW5kaXZpZHVhbC4gUmFw aWRBUEkuY29tIGN1cnJlbnRseSBhIEJhc2ljIHRpZXIgd2hlcmUgeW91IGNhbiBnZXQgYSBudW1iZXIg b2Ygc2VhcmNoZXMgZm9yIGZyZWUsIGFuZCB0aGVuIFBybyBldGMuIHBhaWQgdGllcnMuICBUaGUgQ1JB TlEgdGhlbiBzdW1tYXJpc2VzIHRoZSByZXR1cm5lZCBkYXRhLCBhbmQgaW5zZXJ0cyBpdCBpbnRvIGEg R29vZ2xlIFNoZWV0LlxuXG5JTlNUUlVDVElPTlNcbjEuIEpvaW4gUmFwaWRBUEkuY29tIGFuZCBzaWdu IHVwIHRvIHRoZSBCYXNpYyAoZnJlZSkgdGllci4gIE5hdmlnYXRlIHRvIHRoZSBMaW5rZWRJbiBQcm9m aWxlcyBBUElcbjIuIENyZWF0ZSBhIEdvb2dsZSBTaGVldCBhbmQgZ2V0IHRoZSBTaGVldCBJZCAodGhl IGxvbmcgY29kZSBpbiB0aGUgbWlkZGxlIG9mIHRoZSBVUkwpLiAgU2V0IFNoYXJpbmcgc28gdGhhdCBh bnlvbmUgd2l0aCB0aGUgVVJMIGNhbiBlZGl0IHRoZSBzaGVldFxuMy4gQ29uZmlndXJlIHRoZSBXb3Jr ZmxvdyBwYXJhbWV0ZXJzIChTdGVwICdQJylcbjQuIENsaWNrICdSdW4gRW50aXJlICBXb3JrZmxvdyci LCJjcmVhdGVkQXQiOjE3MDY4MTIyMTA1MTIsInVwZGF0ZWRBdCI6MTcwNjg4NDcyOTcwMywiYWNjZXNz ZWRBdCI6MTcwNjg4NDcyOTcwM30sImdyb3VwcyI6W10sInN0ZXBzIjpbeyJpZCI6ImlkLWVmNjJhYSIs InRpdGxlIjoiUmV0cmlldmUgTGlua2VkSW4gZGV0YWlscyB2aWEgUmFwaWRBUEkiLCJkZXNjcmlwdGlv biI6IkNyZWF0ZSBhIGZ1bmN0aW9uIHRoYXQgcmV0cmlldmVzIHByb2ZpbGUgZGV0YWlscyBmb3IgZWFj aCBvZiBhbiBhcnJheSBvZiBsaW5rZWRpbiBwcm9maWxlIHVybHMgdXNpbmcgdGhlIFJhcGlkQVBJIHNl cnZpY2UuIEZvciBlYWNoIHByb2ZpbGUgdXJsIGluIHR1cm4sIHRoZSBmdW5jdGlvbiBzaG91bGQgdGFr ZSB0aGUgTGlua2VkSW4gcHJvZmlsZSBVUkwsIGEgUmFwaWRBUEkga2V5LCBhIFJhcGlkQVBJIGhvc3Qs IGFuZCBhbiBBUEkgZW5kcG9pbnQgYXMgaW5wdXRzLiBUaGUgZnVuY3Rpb24gc2hvdWxkIG1ha2UgYSBH RVQgcmVxdWVzdCB0byB0aGUgQVBJIGVuZHBvaW50IGZvciByZXRyaWV2aW5nIExpbmtlZEluIHByb2Zp bGUgZGV0YWlscy4gVGhlIHJlcXVlc3Qgc2hvdWxkIGluY2x1ZGUgdGhlICdsaW5rZWRpbl91cmwnIHF1 ZXJ5IHBhcmFtZXRlciB3aXRoIHRoZSBMaW5rZWRJbiBwcm9maWxlIFVSTC4gVGhlIGZ1bmN0aW9uIHNo b3VsZCByZXR1cm4gdGhlIHJlc3BvbnNlIGRhdGEgZm9yIGVhY2ggcHJvZmlsZSwgYW5kIGFkZCBpdCBh cyBhIHJlY29yZCB0byBhIG5ldyBvYmplY3QuICBSZXR1cm4gYWxsIHRoZSByZXNwb25zZSBkYXRhIGlu IGEgc2luZ2xlIG9iamVjdCIsImZsb3dJZCI6ImlkLTAwMDAwMCIsImluZGV4IjoxLCJpbnB1dHMiOnsi aWQtMjI0NzBjIjp7ImlkIjoiaWQtMjI0NzBjIiwibmFtZSI6InJhcGlkYXBpS2V5IiwiZGVzY3JpcHRp b24iOiJSYXBpZEFQSSBLZXkiLCJ0eXBlIjoic3RyaW5nIiwic291cmNlIjp7InR5cGUiOiJlbnYiLCJu YW1lIjoiUmFwaWRBUEkgS2V5In0sImlzQm91bmRUb0NvZGUiOnRydWV9LCJpZC04MjAxZTgiOnsiaWQi OiJpZC04MjAxZTgiLCJuYW1lIjoicmFwaWRhcGlIb3N0IiwiZGVzY3JpcHRpb24iOiJSYXBpZEFQSSBI b3N0IiwidHlwZSI6InN0cmluZyIsInNvdXJjZSI6eyJ0eXBlIjoiZW52IiwibmFtZSI6IlJhcGlkQVBJ IEhvc3QifSwiaXNCb3VuZFRvQ29kZSI6dHJ1ZX0sImlkLWIxZDBkNSI6eyJpZCI6ImlkLWIxZDBkNSIs Im5hbWUiOiJlbmRwb2ludCIsImRlc2NyaXB0aW9uIjoiQVBJIGVuZHBvaW50IiwidHlwZSI6InN0cmlu ZyIsInNvdXJjZSI6eyJ0eXBlIjoiZW52IiwibmFtZSI6IkFQSSBFbmRwb2ludCJ9LCJpc0JvdW5kVG9D b2RlIjp0cnVlfSwiaWQtMGNiNDJjIjp7Im5hbWUiOiJsaW5rZWRpblByb2ZpbGVzIiwiZGVzY3JpcHRp b24iOiJBcnJheSBvZiBMaW5rZWRJbiBwcm9maWxlIFVSTHMiLCJ0eXBlIjoiYXJyYXkiLCJpZCI6Imlk LTBjYjQyYyIsInNvdXJjZSI6eyJ0eXBlIjoiZW52IiwibmFtZSI6IkxpbmtlZEluIFByb2ZpbGUifSwi aXNCb3VuZFRvQ29kZSI6dHJ1ZX19LCJvdXRwdXRzIjp7ImlkLTRmNTY1YSI6eyJpZCI6ImlkLTRmNTY1 YSIsIm5hbWUiOiJsaW5rZWRpblByb2ZpbGVEZXRhaWxzIiwiZGVzY3JpcHRpb24iOiJPYmplY3QgY29u dGFpbmluZyBMaW5rZWRJbiBwcm9maWxlIGRldGFpbHMgZm9yIGVhY2ggcHJvZmlsZSBVUkwiLCJ0eXBl Ijoib2JqZWN0IiwiaXNCb3VuZFRvQ29kZSI6dHJ1ZX19LCJpbXBsZW1lbnRhdGlvbiI6eyJjb2RlIjoi Y29uc3QgYXhpb3MgPSByZXF1aXJlKCdheGlvcycpO1xuXG5hc3luYyBmdW5jdGlvbiBnZXRMaW5rZWRp blByb2ZpbGVEZXRhaWxzKHJhcGlkYXBpS2V5LCByYXBpZGFwaUhvc3QsIGVuZHBvaW50LCBsaW5rZWRp blByb2ZpbGVzKSB7XG4gICAgY29uc3QgbGlua2VkaW5Qcm9maWxlRGV0YWlscyA9IHt9O1xuXG4gICAg Zm9yIChjb25zdCBwcm9maWxlIG9mIGxpbmtlZGluUHJvZmlsZXMpIHtcbiAgICAgICAgY29uc3Qgb3B0 aW9ucyA9IHtcbiAgICAgICAgICAgIG1ldGhvZDogJ0dFVCcsXG4gICAgICAgICAgICB1cmw6IGVuZHBv aW50LFxuICAgICAgICAgICAgcGFyYW1zOiB7bGlua2VkaW5fdXJsOiBwcm9maWxlfSxcbiAgICAgICAg ICAgIGhlYWRlcnM6IHtcbiAgICAgICAgICAgICAgICAneC1yYXBpZGFwaS1rZXknOiByYXBpZGFwaUtl eSxcbiAgICAgICAgICAgICAgICAneC1yYXBpZGFwaS1ob3N0JzogcmFwaWRhcGlIb3N0XG4gICAgICAg ICAgICB9XG4gICAgICAgIH07XG5cbiAgICAgICAgY29uc3QgcmVzcG9uc2UgPSBhd2FpdCBheGlvcy5y ZXF1ZXN0KG9wdGlvbnMpO1xuICAgICAgICBsaW5rZWRpblByb2ZpbGVEZXRhaWxzW3Byb2ZpbGVdID0g cmVzcG9uc2UuZGF0YTtcbiAgICB9XG5cbiAgICByZXR1cm4geyBsaW5rZWRpblByb2ZpbGVEZXRhaWxz IH07XG59IiwiZW50cnlGdW5jTmFtZSI6ImdldExpbmtlZGluUHJvZmlsZURldGFpbHMiLCJkZXBlbmRl bmNpZXMiOlsiYXhpb3MiXSwic3VtbWFyeSI6IlJldHJpZXZlcyBMaW5rZWRJbiBwcm9maWxlIGRldGFp bHMgZm9yIGVhY2ggcHJvZmlsZSBVUkwgdXNpbmcgdGhlIFJhcGlkQVBJIHNlcnZpY2UuIiwiYXBpcyI6 W10sInNpZ25hdHVyZSI6InUrQ3FCNmtBVE9wQzUxNjNhbkI4TnJReXgrNjhvWldXanJyTU9XVEhIV2Y0 eDBKSjFZaURKUkFiTGthTlQwQUdOaXhPb2pzSDlJc1VGbkhpaFZ2aUF3PT0iLCJwYXJhbWV0ZXJzSGFz aCI6IjRmMTNhMDExODRjMmU1MmY3YzU3NjdiYTBiY2NiMmVmYTU1NTg3ZDcifX0seyJpZCI6ImlkLTg0 MGM5OCIsInRpdGxlIjoiU3VtbWFyaXNlIHRoZSByZWNvcmRzIiwiZGVzY3JpcHRpb24iOiJFeHRyYWN0 IHRoZSB2YWx1ZXMgZm9yIG5hbWUsIHJvbGUsIGNvbXBhbnksIGNvbXBhbnlfd2Vic2l0ZSBhbmQgYWJv dXQgaW4gZWFjaCByZWNvcmQgYW5kIHJldHVybiB0aGVtIGFzIGEgbmV3IG9iamVjdC4gIiwiZmxvd0lk IjoiaWQtMDAwMDAwIiwiaW5kZXgiOjIsImlucHV0cyI6eyJpZC0zNmE2NmQiOnsiaWQiOiJpZC0zNmE2 NmQiLCJuYW1lIjoibGlua2VkaW5SZWNvcmRzIiwiZGVzY3JpcHRpb24iOiJMaW5rZWRJbiByZWNvcmRz IiwidHlwZSI6Im9iamVjdCIsInNvdXJjZSI6eyJ0eXBlIjoib3V0cHV0Iiwic3RlcElkIjoiaWQtZWY2 MmFhIiwib3V0cHV0SWQiOiJpZC00ZjU2NWEifSwiaXNCb3VuZFRvQ29kZSI6dHJ1ZX19LCJvdXRwdXRz Ijp7ImlkLWQ5NDM3MiI6eyJpZCI6ImlkLWQ5NDM3MiIsIm5hbWUiOiJzdW1tYXJ5IiwiZGVzY3JpcHRp b24iOiJPYmplY3Qgd2l0aCBleHRyYWN0ZWQgdmFsdWVzIGZvciBuYW1lLCByb2xlLCBjb21wYW55LCBj b21wYW55X3dlYnNpdGUsIGFuZCBhYm91dCBmb3IgZWFjaCByZWNvcmQiLCJ0eXBlIjoib2JqZWN0Iiwi aXNCb3VuZFRvQ29kZSI6dHJ1ZX19LCJpbXBsZW1lbnRhdGlvbiI6eyJjb2RlIjoiZnVuY3Rpb24gZXh0 cmFjdExpbmtlZEluRGF0YShsaW5rZWRpblJlY29yZHMpIHtcbiAgICBjb25zdCBzdW1tYXJ5ID0ge307 XG5cbiAgICBmb3IgKGNvbnN0IFt1cmwsIHJlY29yZF0gb2YgT2JqZWN0LmVudHJpZXMobGlua2VkaW5S ZWNvcmRzKSkge1xuICAgICAgICBjb25zdCBkYXRhID0gcmVjb3JkLmRhdGE7XG4gICAgICAgIHN1bW1h cnlbdXJsXSA9IHtcbiAgICAgICAgICAgIG5hbWU6IGRhdGEuZnVsbF9uYW1lLFxuICAgICAgICAgICAg cm9sZTogZGF0YS5qb2JfdGl0bGUsXG4gICAgICAgICAgICBjb21wYW55OiBkYXRhLmNvbXBhbnksXG4g ICAgICAgICAgICBjb21wYW55X3dlYnNpdGU6IGRhdGEuY29tcGFueV93ZWJzaXRlLFxuICAgICAgICAg ICAgYWJvdXQ6IGRhdGEuYWJvdXRcbiAgICAgICAgfTtcbiAgICB9XG5cbiAgICByZXR1cm4geyBzdW1t YXJ5IH07XG59IiwiZW50cnlGdW5jTmFtZSI6ImV4dHJhY3RMaW5rZWRJbkRhdGEiLCJkZXBlbmRlbmNp ZXMiOltdLCJzdW1tYXJ5IjoiRXh0cmFjdHMgc3BlY2lmaWMgZmllbGRzIGZyb20gTGlua2VkSW4gcmVj b3Jkcy4iLCJhcGlzIjpbXSwic2lnbmF0dXJlIjoiMFV1R0ZmblFad1dxTHdUNlJHYmVmdStyZFM0bTcz VTFVVHV2cXkrc1AwSVk2SGtkR1BnQUd6RTRSU3V0b3VaUU5XZ2FzZzZiY3hISzFGOUlhV2xCQ3c9PSIs InBhcmFtZXRlcnNIYXNoIjoiYWU4MjM1MWQ3ZjRjYzEwNDBlNzJlMjYwY2RkZDUzNjIwMWZhMGU3NSJ9 fSx7ImlkIjoiaWQtMjE5MzM2IiwidGl0bGUiOiJJbnNlcnQgdG8gR29vZ2xlIFNoZWV0IiwiZGVzY3Jp cHRpb24iOiJJIHdhbnQgdG8gaW5zZXJ0IHNvbWUgcmVjb3JkcyBpbnRvIGEgR29vZ2xlIFNoZWV0LiAg VHJhbnNmb3JtIHRoZSBwcm92aWRlZCByZWNvcmRzIGludG8gdGhlIGdvb2dsZSBzaGVldHMgZXhwZWN0 ZWQgZm9ybWF0IGJlZm9yZSBpbnNlcnRpbmcgdGhlbSBpbnRvIHRoZSBHb29nbGUgU2hlZXQuIEVhY2gg cmVjb3JkIHNob3VsZCBiZSByZXByZXNlbnRlZCBhcyBhbiBhcnJheSwgd2hlcmUgdGhlIHZhbHVlcyBv ZiB0aGUgYXJyYXkgYXJlIG1hcHBlZCB0byB0aGUgY2VsbHMgaW4gYSByb3cuIE1vZGlmeSB0aGUgZGF0 YSBiZWZvcmUgbWFraW5nIHRoZSBBUEkgcmVxdWVzdC4iLCJmbG93SWQiOiJpZC0wMDAwMDAiLCJpbmRl eCI6MywiaW5wdXRzIjp7ImlkLWM1ZGIwMSI6eyJpZCI6ImlkLWM1ZGIwMSIsIm5hbWUiOiJyZWNvcmRz IiwiZGVzY3JpcHRpb24iOiJSZWNvcmRzIHRvIGJlIGluc2VydGVkIiwidHlwZSI6InsnaHR0cHM6Ly93 d3cubGlua2VkaW4uY29tL2luL3RvYnlyb3dsYW5kLyc6e25hbWU6c3RyaW5nO3JvbGU6c3RyaW5nO2Nv bXBhbnk6c3RyaW5nO2NvbXBhbnlfd2Vic2l0ZTpzdHJpbmc7YWJvdXQ6c3RyaW5nO30iLCJzb3VyY2Ui OnsidHlwZSI6Im91dHB1dCIsInN0ZXBJZCI6ImlkLTg0MGM5OCIsIm91dHB1dElkIjoiaWQtZDk0Mzcy In0sImlzQm91bmRUb0NvZGUiOnRydWV9LCJpZC0xZTA3NzQiOnsibmFtZSI6InNoZWV0SWQiLCJkZXNj cmlwdGlvbiI6IlNoZWV0IElEICh0aGUgbG9uZyBjb2RlIGluIHRoZSBVUkwpIiwidHlwZSI6InN0cmlu ZyIsImlkIjoiaWQtMWUwNzc0Iiwic291cmNlIjp7InR5cGUiOiJlbnYiLCJuYW1lIjoiR29vZ2xlIFNo ZWV0IElkIn0sImlzQm91bmRUb0NvZGUiOnRydWV9fSwib3V0cHV0cyI6eyJpZC1hNmVjMzciOnsiaWQi OiJpZC1hNmVjMzciLCJuYW1lIjoicmVzdWx0IiwiZGVzY3JpcHRpb24iOiJSZXN1bHQgb2YgdGhlIG9w ZXJhdGlvbiIsInR5cGUiOiJ1bmtub3duIiwiaXNCb3VuZFRvQ29kZSI6dHJ1ZX19LCJpbXBsZW1lbnRh dGlvbiI6eyJjb2RlIjoiY29uc3QgYXhpb3MgPSByZXF1aXJlKCdheGlvcycpO1xuXG5jb25zdCBCQVNF X1VSTCA9ICdodHRwczovL3NoZWV0cy5nb29nbGVhcGlzLmNvbS92NC9zcHJlYWRzaGVldHMnO1xuXG5h c3luYyBmdW5jdGlvbiBpbnNlcnRSZWNvcmRzKHJlY29yZHMsIHNoZWV0SWQpIHtcbiAgICBjb25zdCBk YXRhID0gT2JqZWN0LnZhbHVlcyhyZWNvcmRzKS5tYXAocmVjb3JkID0+IE9iamVjdC52YWx1ZXMocmVj b3JkKSk7XG4gICAgY29uc3QgdXJsID0gYCR7QkFTRV9VUkx9LyR7c2hlZXRJZH0vdmFsdWVzL0ExOmFw cGVuZD92YWx1ZUlucHV0T3B0aW9uPVVTRVJfRU5URVJFRGA7XG4gICAgY29uc3QgcmVzcG9uc2UgPSBh d2FpdCBheGlvcy5wb3N0KHVybCwgeyB2YWx1ZXM6IGRhdGEgfSk7XG4gICAgcmV0dXJuIHsgcmVzdWx0 OiByZXNwb25zZS5kYXRhLnVwZGF0ZXMudXBkYXRlZFJhbmdlIH07XG59IiwiZW50cnlGdW5jTmFtZSI6 Imluc2VydFJlY29yZHMiLCJkZXBlbmRlbmNpZXMiOlsiYXhpb3MiXSwic3VtbWFyeSI6Ikluc2VydHMg cmVjb3JkcyBpbnRvIGEgR29vZ2xlIFNoZWV0LiIsImFwaXMiOlsiZ29vZ2xlc2hlZXRzIl0sInNpZ25h dHVyZSI6IlVCU1hPcGRFQWVUdVcvdTRIYXg4bk92UFM4dS8yRHh3QmhMc0lGTG02VlNHdlZiMnZzeEZX OGFQK2k5TlhZSUJHeE9hT3Q1cFc4QkRhbDVxN29xc0J3PT0iLCJwYXJhbWV0ZXJzSGFzaCI6IjY0N2Q5 MmVjMjkwNWViMWJiZDEwNGQ2ODUyYjMxNjhiZjAxYzBkMjUifX1dLCJwYXJhbWV0ZXJzIjpbeyJrZXki OiJMaW5rZWRJbiBQcm9maWxlIn0seyJrZXkiOiJSYXBpZEFQSSBLZXkifSx7ImtleSI6IlJhcGlkQVBJ IEhvc3QifSx7ImtleSI6IkFQSSBFbmRwb2ludCJ9LHsia2V5IjoiR29vZ2xlIFNoZWV0IElkIn1dfQ== ------------------------------------- END --------------------------------------

Copy (for insertion)
Inputs
  1. Google Sheet ID
  2. Array of linkedin urls in ["url1", "url2",..] format
  3. RapidAPI api key
  4. RapidAPI Endpoint URL
  5. RapidAPI Host
AI Description
Required connections
Connected
Connected
Connected
Connected
Connected
Connected
Connected
Connected
Connected
Connected
Useful links

www.rapidapi.com

https://www.linkedin.com/help/linkedin/answer/a1341387#:~:text=In%20order%20to%20protect%20our,automate%20activity%20on%20LinkedIn's%20website