LinkedIn Profile Collector

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 --------------------------------------

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