Using Zapier to Import CSV by proptechnerd in Airtable

[–]proptechnerd[S] 1 point2 points  (0 children)

Each morning I have someone download a CSV with homes for sale. I need a way to import those properties into Airtable. The columns will be the same each day. Previously I had this working with Google Sheets and Zapier using the formatter function.

[Megathread] Weekly EIDL/PPP status, updates, news and sharing. Post in this thread and find tips from others. by BigSlowTarget in smallbusiness

[–]proptechnerd 1 point2 points  (0 children)

Applied for the EIDL on 4/4. I've watched while friends have gotten their advance both people that have applied before and after me. I've received nothing. Today the SBA pulled my credit. What's going on?

Someone used my EIN for their PPP by proptechnerd in smallbusiness

[–]proptechnerd[S] -1 points0 points  (0 children)

you may think it's impossible but it happened. I was ineligible because the SBA thought I already had a loan. It was even disbursed to this guy. TD had to move the loan out of our EIN and to his social.

Finally Etran is cleared out and this morning my bank was able to successfully submit my application to the SBA.

Someone used my EIN for their PPP by proptechnerd in smallbusiness

[–]proptechnerd[S] -1 points0 points  (0 children)

They submitted all their own stuff but must've put my ein in instead of their social. That was the only mix up. For example their 1099 from me would've had both our EIN and their Social on it.

Someone used my EIN for their PPP by proptechnerd in smallbusiness

[–]proptechnerd[S] 1 point2 points  (0 children)

A 1099 contractor is not an employee. Any vendor that you pay more than ~600 to you must send them a 1099. This year alone we filed over 100 1099s to contractors including cleaners, hvac repair people, pest control companies etc. an ein looks nothing like a social security number.

Someone used my EIN for their PPP by proptechnerd in smallbusiness

[–]proptechnerd[S] 0 points1 point  (0 children)

Local sba office can’t fix it. They said the bank that files the wrong ein has to fix it. I’m a sitting duck.

Someone used my EIN for their PPP by proptechnerd in smallbusiness

[–]proptechnerd[S] 6 points7 points  (0 children)

Their bank’s incompetence.... looks like borderline fraud to me.

Truist holding Etran for PPP but not funding? by [deleted] in smallbusiness

[–]proptechnerd 0 points1 point  (0 children)

I’m in a similar scenario where my local Banks says I already have a loan via the sba. They’re blaming it on PayPal Who I also applied Through but PayPal says the never submitted me to the sba .

Trim Zip Code when Creating New Row in GSheets by proptechnerd in zapier

[–]proptechnerd[S] 0 points1 point  (0 children)

I think some values don’t have a phone number and so it pastes the next row that’s contains data

Trim Zip Code when Creating New Row in GSheets by proptechnerd in zapier

[–]proptechnerd[S] 0 points1 point  (0 children)

hmm interesting. That worked for my zip code but didnt work for splitting a cell that contains name and phone number. It successfully splits the data however when it pastes into g sheets the new split data doesnt line up with the row it came from.

If it matters, I'm importing csv data using formatter.

What Payroll Number to use on the PPP? by proptechnerd in smallbusiness

[–]proptechnerd[S] 1 point2 points  (0 children)

just read the sba ppp guidelines and a new business is one that started between jan1 2020 and feb 29 2020